{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Input","Design Load Rating","State Legal Load Rating","SHV Load Rating","Summary","Modulus of Soil Reaction","Calcs","Options"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,9,12,18],[21,0,21,8],[23,0,23,8],[9,2,9,3],[9,4,9,5],[15,0,15,8],[17,0,17,8],[13,0,13,8],[10,4,10,5],[11,4,11,5],[0,3,0,5],[5,2,5,3],[7,2,7,3],[5,4,5,5],[6,4,6,5],[7,4,7,5],[33,0,33,8],[36,0,36,8],[37,0,37,8],[19,0,19,8],[25,0,25,8],[27,0,27,8],[29,0,29,8],[2,4,2,5],[3,4,3,5],[6,1,6,3],[31,0,31,1],[32,0,32,8]]}
[null,null,null,"INTRODUCTION",null,null,null,null,null,"DISCLAIMER: The Louisiana Department of Transportation and Development (LaDOTD) makes these documents and software available on an \"as is\" basis. All warranties and representations of any kind with regard to said documents and software are disclaimed, including the implied warranties of merchantability and fitness for a particular use. Under no circumstances will the LaDOTD, or any of its officers or employees be liable for any consequential, incidental, special or exemplary damages even if apprised of the likelihood of such damages occurring. The LaDOTD does not warrant the documents and software against deficiencies of any kind. The use of any of these documents and software for work that is under contract with the LaDOTD does not relieve the contractor from any obligations assumed by the contract, or from complete and proper fulfillment of the terms of the contract, nor does it entitle the contractor to compensation for damages or loss which could be attributed to such use.\n\nInformation on this web site is posted to aid in the efficient dissemination of information to designers. The data contained within this web site is periodically updated. Designers are responsible to be aware of any updates and incorporate significant changes into their final design."]
[]
[null,null,null,"Date:","2020-01-02"]
[null,null,null,"Version:","1.0"]
[]
[null,null,"Developed By:",null,"Qiming Chen"]
[null,"Checked By:",null,null,"Suba Herath",null," "]
[null,null,"Reviewed By:","QA","Yan \"Seraphy\" Shen",null," "]
[]
[null,null,"Maintained By:",null,"Qiming Chen"]
[null,null,null,"Email:","qiming.chen@la.gov"]
[null,null,null,"Phone:","225-379-1412"]
[]
["Genearl: This spreadsheet is designed to aid a qualified engineer in completing the bridge load rating analysis of a smooth steel pipe culvert structure (DOTD culvert structure type: smooth STLPIP, RRTKCR). Sound engineering judgement and familiariry with the analysis are required to choose appropriate input values and to recognize situations that may deviate from the standard case on which these spreadsheets based. This spreadsheet is comprised of nine worksheets: Introduction, Input, Deisng Load Rating, State Legal Load Rating, SHV load rating, Summary, Modulus of Soil Reaction, Options, and Calcs. The Input and Summary worksheets are protected. The passoword is \"Rating\"."]
[]
["Input Worksheet:  Yellow shaded cells are required input, please input a appropriate value or choose a appropriate option from the drop-down list."]
[]
["Design Load Rating: This worksheet will be updated automatically after inputting the appropriate values in the Input worksheet. This worksheet contains rating factors for HL-93 design truck and tandem."]
[]
["State Legal Load Rating:  This worksheet will be updated automatically after inputting the appropriate values in the Input worksheet. This worksheet contains rating factors for state legal loads: LA Type 3, LA Type 3-S2, Type 3-3, LA Type 6, and LA Type 8."]
[]
["SHV Load Rating:   This worksheet will be updated automatically after inputting the appropriate values in the Input worksheet. This worksheet contains rating factors for special hauling vehicles: NRL, SU4, SU5, SU6, and SU7."]
[]
["Summary Worksheet:  This worksheet will be updated automatically after inputting the appropriate values in the Input worksheet. This worksheet contains the general information and rating factors of the smooth steel pipe defined in the Input worksheet"]
[]
["Modulus of Soil Reaction:  This worksheet is a reference table that is reproduced from AWWA's Steel Pipe Design Manual"]
[]
["Options Worksheet (Hidden):  This worksheet contains tabulated values that are accessed using lookup funcions based on selections from the drop down cells in the Input worksheet."]
[]
["Calcs Worksheet (Hidden):  This worksheet contains the calculations to obtain rating weigtht, governing rating factor, governing load model, and recommended posting load in the Summary Worksheet."]
[]
["References:"]
["AASHTO LRFD Bridge Design Specifications, Eighth Edition, Section 3, 4 & 12."]
["AWWA M11 Steel Pipe: A Guide for Design and Installation, Fifth Edition."]
["ALA Guideline for the Design of Buried Steel Pipe, July 2001."]
["NRCS, NEH 636 Chap. 52 Structural Design of Flexible Conduits, June 2005."]
["LaDOTD Bridge Design & Evaluation Manual REV 7, Section 6."]
["AASHTO Manual for Bridge Evaluation, Third Edition."]

{"sheet":"Input","index":1,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,0,52,1],[53,0,53,1],[15,0,15,2],[15,5,15,8],[54,0,54,1],[34,0,34,1],[26,0,26,2],[43,0,43,1],[35,0,35,1],[42,0,42,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[4,10,4,12],[2,4,2,7],[2,8,2,9],[2,10,2,12],[3,4,3,7],[3,8,3,9],[3,10,3,12],[6,4,6,7],[6,8,6,9],[7,1,7,2],[5,10,5,12],[6,10,6,12],[13,9,13,10],[7,4,7,7],[7,8,7,9],[7,10,7,12],[8,1,8,12],[12,4,12,8],[12,9,12,12],[39,0,39,1],[38,0,38,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[14,5,14,8],[4,4,4,7],[4,8,4,9],[23,0,23,1],[0,0,0,2],[2,1,2,2],[4,1,4,2],[6,1,6,2],[5,1,5,2],[3,1,3,2],[10,0,10,3],[12,0,12,3],[14,0,14,2],[5,4,5,7],[5,8,5,9],[13,5,13,8]]}
["Bridge Data"]
[]
["District    ",2,null,"Structure Number",2264300100701,null,null,null,"Bridge Name ",null,"Drain Canal"]
["Parish   ",26,null,"Recall Number",20459,null,null,null,"Inspection Date",null,"02/12/2018"]
["Route","LA 3139",null,"Year Built",1986,null,null,null,"Overall",null,"7"]
["Bridge Posting","-",null,"Design Load","-",null,null,null,"Deck",null,"N"]
["Bridge Type","STLPIP",null,"Roadway Width",38,null,null,null,"Super",null,"N"]
["Bridge Length",25,null,"Plan Location",null,null,null,null,"Sub",null,"N"]
["Standard Plan"," "]
[]
["Bridge Load Rating Summary"]
[]
["Dead Load",null,null,null,"LRFR Evaluation Factors",null,null,null,null,"Traffic"]
["Surface Thickness (in)",null,null,63,"Condition Factor (φc)*","-",null,null,null,"ADTT (one way)",null,null,200,null,"Yellow shaded areas are required input."]
["Wearing Surface Type",null,null,"-","System Factor (φs)",1,null,null,null,null,null,null,null,null,"Input a value or choose a option from a drop-down list."]
["Non-Structural Attachments",null,null,"-","Surface Rating ","-"]
["*Condition is already considered at element level."]
[]
["Pipe Information"]
["Basic Information"]
["Pipe Type",null,"Circular"]
["Pipe Size (in)",null,96,"Inside Diameter"]
["Wall Thickness (in)",null,1.0649999999999999," "]
["Yield Stress (ksi)",null,33," "]
[]
["Lining and Coating Type"]
["Flexible Lining and Coating"]
[]
["Field Measurement (see the diagram)",null,null," "]
["Actual Maximum Top Radius (R) (ft)",null,4," "]
["Pipe Crown Deflection (D/Pipe Size)",null,0," "]
["Metal Loss","DOTD Type A",0]
[]
["Soil Properties"]
["Modulus of Soil Reaction (psi)"," ",1000,"AWWA Table 5-3"]
["Poisson's ratio of the soil, νs ="," ",0.3]
[]
["Earth Loads"]
["Fill Height (ft)"," ",{"$f":"D14/12","v":5.25}," "]
["Soil Unit Weight (pcf)"," ",120]
[]
["Water Loads",null,"No"]
["Water Unit Weight (pcf)"," ",62.4]
["Height of Water above Pipe (ft)",null,0]
[]
["Live Load Distribution Factor"]
[" "," ",1.1499999999999999,"LRFD Table 3.6.1.2.6a-1"]
[]
["Load Factors"]
["gDC (Dead Load)  =",null,1.25,"LRFD Table 3.4.1-2"]
["gEV (Vertical Earth Pressure)  =",null,1.95,"LRFD Table 3.4.1-2"]
["gLL   (HL-93 - Inventory)  =",null,1.75,"MBE Table 6A.4.2.2-1"]
["gLL   (HL-93 - Operating)  =",null,1.35,"MBE Table 6A.4.2.2-1"]
["gLL (Legal Loads) =",null,2,"MBE 6A.5.12.10.3"]
["gLL (Special Hauling Loads) =",null,2,"MBE 6A.5.12.10.3"]
[null," "]

{"sheet":"Design Load Rating","index":2,"n_rows":320,"n_cols":9,"rows_kept":320,"cut":false,"hidden":false,"merged":[[219,0,219,3],[128,0,128,3],[138,0,138,3],[187,0,187,3],[38,0,38,2],[100,0,100,1],[39,0,39,2],[40,0,40,2],[60,1,60,2],[62,1,62,2],[63,1,63,2],[81,1,82,1],[91,1,91,2],[92,1,92,2],[318,0,319,0],[318,5,319,5],[249,0,249,5],[295,0,295,2],[301,0,301,2],[314,0,314,4],[316,0,317,0],[313,0,313,5],[284,0,284,2],[255,0,255,2],[264,0,264,2],[269,0,269,2],[19,1,19,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[74,1,75,1],[61,1,61,2],[59,1,59,2],[25,0,25,1],[46,1,46,2],[27,0,27,2],[29,0,29,2],[36,0,36,2],[52,0,52,1],[28,0,28,2],[35,0,35,2],[37,0,37,2],[7,0,7,2],[8,0,8,2],[17,1,17,2],[18,1,18,2],[14,0,14,1],[0,0,0,5],[2,0,2,1],[4,0,4,5],[5,0,5,5],[6,0,6,5],[235,1,236,1],[109,1,109,2],[110,1,110,2],[127,0,127,3],[129,0,129,1],[137,0,137,3],[139,0,139,1],[229,1,230,1],[218,0,218,3],[220,0,220,1],[186,0,186,3],[188,0,188,1],[192,0,206,0],[209,0,211,0],[157,0,171,0],[175,0,179,0]]}
["LRFR of Smooth Steel Pipe Structures                                     "]
[]
["A.   Design Dimensions"]
[]
["   1.  For typical structures, use the actual field measured span for calculations."]
["   2.  For those deflected over 5%, use 2 x the top radius (2 Rt) in lieu of span for calculations."]
[]
["Then, Span Length used in Load Rating Calculation =",null,null,{"$f":" IF(Input!$C$31<=5%,Input!$C$22/12,2*Input!$C$30)","v":8},"ft"]
["Then, Rt used in Load Rating Calculation =",null,null,{"$f":"Input!$C$30","v":4},"ft"]
[]
[null,"Inside radius of the steel pipe, ri =",null,{"$f":"Input!$C$22/2","v":48},"in"]
[null,"Outside radius of the steel pipe, ro =",null,{"$f":"(Input!$C$22/2+Input!$C$23)","v":49.064999999999998},"in"]
[null,"Mean radius of the steel pipe, r =",null,{"$f":"(Input!$C$22+Input!$C$23)/2","v":48.532499999999999},"in"]
[]
["B.   Pipe Properties",null,null," "]
[]
["Mechanical Properties:"]
[null,"Fy = Minimum Yield Point of the Steel",null,{"$f":"Input!$C$24","v":33},"ksi"]
[null,"Fu = Minimum Tensile Strength of the Steel",null,45,"ksi"]
[null,"E = Modulus of Elasticity of Steel",null,29000,"ksi"]
[]
["Section Properties:"]
[null,null,"As (in2/ft) =",{"$f":"Input!$C$23*12","v":12.78}]
[null,null,"I (in4/in) =",{"$f":"Input!$C$23^3/12","v":0.10066246874999997}]
[]
["C.  Capacity:"]
[]
["φ = Resistance Factor for wall area and buckling (LRFD Table 12.5.5-1)",null,null,1]
["φloss = Section Properties reduction factor on the basis of metal loss from the materials field evaluation =    ",null,null,{"$f":"1-Input!$C$32","v":1}]
["φbkl = Buckling Strength Reduction Factor = ((1-d)/(1+d)2)3 =",null,null,{"$f":"((1-Input!$C$31)/(1+Input!C31)^2)^3","v":1},"(NRCS NEH 636, 52-34)"]
[]
["Calculate the qb (buckling capacity of the pipe wall) :"]
[]
[" ",null,null,null,"(AWWA Eq 5-7)"]
[]
["Scalar calibration factor to account for some nonlinear effects , Cn =",null,null,0.55000000000000004," "]
["Pipe wall stiffness, EI =",null,null,{"$f":"$D$20*1000*$D$24","v":2919211.5937499991},"lb.in"]
["Factor to account for variability in stiffness of compacted soil, φsoil =",null,null,0.9," "]
["Modulus of soil reaction, E' = ",null,null,{"$f":"Input!$C$35","v":1000},"psi"]
["Modulus correction factor for Poisson's ratio of the soil, kv =",null,null,{"$f":"(1+Input!$C$36)*(1-2*Input!$C$36)/(1-Input!$C$36)","v":0.74285714285714288}]
["Correction factor for depth of fill, RH =",null,null,{"$f":"11.4/(11+2*$D$13/12/Input!$C$39)","v":0.90903912969186085}]
[]
[null,"Therefore,","qb =",{"$f":"$D$28*Input!$F$15*$D$29*$D$30*1.2*$D$36*$D$37^0.33*($D$38*$D$39*$D$40)^0.67*$D$41/$D$12","v":129.93955789670849},"psi"]
[" "]
["Calculate the σcap (flexural capacity of the pipe wall) :"]
[]
[]
[]
[]
[null,"Therefore,","Tcap = ",{"$f":"$D$28*Input!$F$15*$D$29*$D$18*$D$23","v":421.73999999999995},"kips/ft"]
[null,null,"σcap = ",{"$f":"$D$28*Input!$F$15*$D$29*$D$18","v":33},"ksi"]
[]
["D. Dead Load Analysis:"]
["Calculate the qs (pressure at crown due to earth cover) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,null,"(AWWA Eq 5-3)"]
[]
[null,"Outside diameter of coated pipe (in) , Dc =",null,{"$f":"2*$D$12","v":98.13}," "]
[null,"Earth load (lb/ft), Wc =",null,{"$f":"Input!$C$40*Input!$C$39*$D$60/12","v":5151.8249999999998}," "]
[null,"Height of Water above Pipe (ft), Hw =",null,{"$f":"IF(Input!$C$42=\"Yes\",Input!$C$44,0)","v":0}]
[null,"Water buoyancy factor, Rw = 1-0.33 (Hw/H)",null,{"$f":"1-0.33*D62/Input!$C$39","v":1}," "]
[null,"Outside diameter of pipe (in), D0 =",null,{"$f":"2*$D$12","v":98.13}," "]
[]
[null,"Therefore,","qs = ",{"$f":"$D$63*$D$61/12/$D$64","v":4.375},"psi"]
[]
["Calculate the qw (pressure at crown due to water) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,"Therefore,","qw = ",{"$f":"Input!$C$43*$D$62/144","v":0},"psi"]
[]
["Calculate the σS (circumferential stress due to earth cover) :"]
[null,"TE = higher value of :","1.   γs H (S/2) =",{"$f":"Input!$C$40*Input!$C$39*$D$8/2/1000","v":2.52},"kips/ft"]
[null,null,"2.   γs H Rt =",{"$f":"Input!$C$40*Input!$C$39*$D$9/1000","v":2.52},"kips/ft"]
[]
[null,"Therefore,","TS = ",{"$f":"MAX($D$75,$D$76)","v":2.52},"kips/ft"]
[null,null,"σS = TS/As =",{"$f":"D78/$D$23","v":0.19718309859154931},"ksi"]
[]
["Calculate the σW (circumferential stress due to water) :",null,null,null,null,null,null," "]
[null,"TE = higher value of :","1.   γw Hw (S/2) =",{"$f":"Input!$C$43*D62*$D$8/2/1000","v":0},"kips/ft"]
[null,null,"2.   γw Hw Rt =",{"$f":"Input!$C$43*D62*$D$9/1000","v":0},"kips/ft"," "]
[]
[null,"Therefore,","TW = ",{"$f":"MAX($D$82,$D$83)","v":0},"kips/ft"]
[null,null,"σW = TW/As =",{"$f":"D85/$D$23","v":0},"ksi"]
[]
["Calculate the σD_bw (Through-Wall Bending Stress)"]
[]
["Ovality",null,null,"(ALA Eq 4-2)"]
[]
[null,"Deflection lag factor, Dl =",null,1," "]
[null,"Bedding constant, K =",null,0.1]
[]
[null,"Therefore,","Δy/D0 = ",{"$f":"$D$92*$D$93*$D$66/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":5.0556488097195946E-3}," "]
[]
[null,null,null,"(ALA Eq 4-4)"]
[]
[null,"Therefore,","σD_bw = ",{"$f":"4*$D$20*1000*$D$95*Input!$C$23/(2*$D$12)/1000","v":6.3647697335448763},"ksi"]
[]
["E. Live Load Analysis:"]
[]
["The surface tire contact area for HL-93 loading (per AASHTO LRFD 3.6.1.2.5):"]
[null,null,"wt =",20,"in"," "]
[null,null,"lt =",10,"in"]
[]
["Distribution of wheel loads through earth fills (per AASHTO LRFD 3.6.1.2.6):"]
["1. Single wheel load Distribution:"]
[]
[null,"For H<2 ft, ww = 96+1.44S =",null,{"$f":"(96+1.44*2*$D$11/12)/12","v":8.9599999999999991},"ft"]
[null,"For H≥2 ft, ww = wt/12+LLDF(H)+0.06Di/12 = ",null,{"$f":"$D$104/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":8.1841666666666661},"ft"," "]
[null,null,"lw = lt/12+LLDF(H) = ",{"$f":"$D$105/12+Input!$C$47*Input!$C$39","v":6.8708333333333327},"ft"]
[]
["2. Overlap Check for Fill Height, H<2 ft:"]
[]
["For parallel to culver spans, overlap requirement is:"]
[" lw≥axial spacing, for minimum axial spacing = 4 ft"]
["LLDF>(4-lt/12)*2=",{"$f":"(4-D105/12)/2","v":1.5833333333333333},"which is greater than 1.15 specified in LRFD Table 3.6.1.2.6a."]
[]
[null,null,null,"Therefore overlap is not considered for Fill Height, H<2 ft"]
[]
["HL-93 Truck"]
[null,"Pressure (psf)","Multi-presence Factor (LRFD C3.6.1.1.2)","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"32000/($D$110*$D$112)","v":519.79554708481339},{"$f":"IF(Input!$M$14<100,0.9*1.2,IF(AND(Input!$M$14>=100,Input!$M$14<=1000),0.95*1.2,1.2))","v":1.1399999999999999},{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B124*C124*(1+D124)/144","v":4.5818488477865378},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E124","v":4.5818488477865378}," "]
["      Only single-lane multiple presence factor is applied (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["HL-93 Tandem"]
[null,"Pressure (psf)","Multi-presence Factor (LRFD C3.6.1.1.2)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"25000/($D$110*$D$112)","v":406.09027116001045},{"$f":"IF(Input!$M$14<100,0.9*1.2,IF(AND(Input!$M$14>=100,Input!$M$14<=1000),0.95*1.2,1.2))","v":1.1399999999999999},{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B134*C134*(1+D134)/144","v":3.5795694123332331},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E134","v":3.5795694123332331}," "]
["      Only single-lane multiple presence factor is applied (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["3. Overlap Check for Fill Height, H≥2 ft:"]
[null,null,"For H<Hint-t"]
[null," ",null,null,null,"(LFRD 3.6.1.2.6b-2)"]
[]
[null,"LRFD 3.6.1.2.6b-1","For H≥Hint-t"]
[]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-3)"]
[]
[null,null,"For H<Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-5)"]
[]
[null,"LRFD 3.6.1.2.6b-4","For H≥Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-6)"]
[]
["HL-93 Truck"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",16000]
[null,"Spacing, sw (ft)",6,{"$f":"(C159-$D$104/12-0.06*2*$D$11/12)/Input!$C$47","v":3.3507246376811595},{"$f":"IF(Input!$C$39<'Design Load Rating'!D159, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D159,$D$104/12+Input!$C$47*Input!$C$39+0.06*$D$8*12/12,$D$104/12+C159+Input!$C$47*Input!$C$39+0.06*$D$8*12/12)","v":14.184166666666666}]
[null,"Wheel (lb)",16000," ",null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",8000]
[null,"Spacing, sa (ft)",14,{"$f":"(C177-$D$105/12)/Input!$C$47","v":11.449275362318842},{"$f":"IF(Input!$C$39<'Design Load Rating'!D177, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'Design Load Rating'!D177,'Design Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'Design Load Rating'!$D$105/12+C177+Input!$C$47*Input!$C$39)","v":6.8708333333333327},null,"Gray shaded areas are wheels and axles not considered in analysis because of axle spacing."]
[null,"Axle 2 (lb)",32000]
[null,"Spacing, sa (ft)",14,{"$f":"(C179-$D$105/12)/Input!$C$47","v":11.449275362318842},{"$f":"IF(Input!$C$39<'Design Load Rating'!D179, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'Design Load Rating'!D179,'Design Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'Design Load Rating'!$D$105/12+C179+Input!$C$47*Input!$C$39)","v":6.8708333333333327}]
[null,"Axle 3 (lb)",32000]
[]
[null,"Pressure (psf)","Multi-presence Factor (LRFD C3.6.1.1.2)","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"IF($E$159=\"NO\",$C$158/($D$111*$D$112),IF($E$179=\"NO\",2*$C$158/($F$159*$F$179),4*$C$158/($F$159*$F$179)))","v":328.34978686657149},{"$f":"IF(Input!$M$14<100,0.9*1.2,IF(AND(Input!$M$14>=100,Input!$M$14<=1000),0.95*1.2,1.2))","v":1.1399999999999999},{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B183*C183*(1+D183)/144","v":2.8943093126961319},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E183","v":2.8943093126961319}," "]
["      Only single-lane multiple presence factor is applied (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["HL-93 Tandem"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",12500]
[null,"Spacing, sw (ft)",6,{"$f":"(C194-$D$104/12-0.06*2*$D$11/12)/Input!$C$47","v":3.3507246376811595},{"$f":"IF(Input!$C$39<'Design Load Rating'!D194, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D194,$D$104/12+Input!$C$47*Input!$C$39+0.06*$D$8*12/12,$D$104/12+C194+Input!$C$47*Input!$C$39+0.06*$D$8*12/12)","v":14.184166666666666},null,null," "]
[null,"Wheel (lb)",12500," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",25000]
[null,"Spacing, sa (ft)",4,{"$f":"(C211-$D$105/12)/Input!$C$47","v":2.7536231884057973},{"$f":"IF(Input!$C$39<'Design Load Rating'!D211, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'Design Load Rating'!D211,'Design Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'Design Load Rating'!$D$105/12+C211+Input!$C$47*Input!$C$39)","v":10.870833333333334}]
[null,"Axle 2 (lb)",25000]
[]
[null,"Pressure (psf)","Multi-presence Factor (LRFD C3.6.1.1.2)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"IF(E211=\"NO\",C193/($D$111*$D$112),IF(E194=\"NO\",2*C193/($F$194*$F$211),4*C193/($F$194*$F$211)))","v":324.26743875944828},{"$f":"IF(Input!$M$14<100,0.9*1.2,IF(AND(Input!$M$14>=100,Input!$M$14<=1000),0.95*1.2,1.2))","v":1.1399999999999999},{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B215*C215*(1+D215)/144","v":2.8583245835544751},null," "]
["Two Lanes",null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E215","v":2.8583245835544751}," "]
["      Only single-lane multiple presence factor is applied (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["Calculate the qL (pressure at crown due to live load) :"]
[" "]
["HL-93 Truck","qL=",{"$f":"IF(Input!$C$39<2,'Design Load Rating'!E128,'Design Load Rating'!E187)","v":2.8943093126961319},"psi"," "]
[]
["HL-93 Tandem","qL=",{"$f":"IF(Input!$C$39<2,'Design Load Rating'!E138,'Design Load Rating'!E219)","v":2.8583245835544751},"psi"]
[]
["Calculate the σL (circumferential stress due to live load plus dynamic load allowance) :"]
["HL-93 Truck","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E187*$D$8/2*144/1000","v":1.6671221641129719},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E187*$D$9*144/1000","v":1.6671221641129719},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D230,D231)","v":1.6671221641129719},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D233/$D$23","v":0.13044774367081158},"ksi"]
[]
["HL-93 Tandem","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E219*$D$8/2*144/1000","v":1.6463949601273775},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E219*$D$9*144/1000","v":1.6463949601273775},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D236,D237)","v":1.6463949601273775},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D239/$D$23","v":0.12882589672358197},"ksi"]
[]
["Calculate the σL_bw (Through-Wall Bending Stress)"]
["HL-93 Truck"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C225/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":3.3445968986725804E-3}," "]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D243*Input!$C$23/(2*$D$12)/1000","v":4.2106542429635239},"ksi"]
[]
["HL-93 Tandem",null,"Δy/D0 = ",{"$f":"$D$92*$D$93*C227/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":3.303013777974729E-3}]
[null,null,"σL_bw = ",{"$f":"4*$D$20*1000*D246*Input!$C$23/(2*$D$12)/1000","v":4.1583034966982373},"ksi"]
[]
[]
["F.   Load Rating Analysis"]
["I. Rating based on buckling"]
["      1.  Operating Load Rating Factor (RFO):"]
[]
[]
[]
["Operating Load Rating Factors, RFO"]
[null,"HL-93 Truck","HL-93 Tandem"]
["qb",{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849}]
["qs ",{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375}]
["qw",{"$f":"$D$72","v":0},{"$f":"$D$72","v":0}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["ql",{"$f":"$C$225","v":2.8943093126961319},{"$f":"$C$227","v":2.8583245835544751}]
["gLL ",{"$f":"Input!$C$53","v":1.35},{"$f":"Input!$C$53","v":1.35}]
["RFo-b",{"$f":"(B258-B261*B259)/(B262*B263)","v":31.072034882033208},{"$f":"(C258-C261*C259)/(C262*C263)","v":31.463214654107812}]
[]
["      2.  Inventory Load Rating Factor (RFi):"]
[]
[]
[]
["Inventory Load Rating Factor, RFi"]
[null,"HL-93 Truck","HL-93 Tandem"]
["qb",{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849}]
["qs ",{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375}]
["qw",{"$f":"$D$72","v":0},{"$f":"$D$72","v":0}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["ql",{"$f":"$C$225","v":2.8943093126961319},{"$f":"$C$227","v":2.8583245835544751}]
["gLL ",{"$f":"Input!$C$52","v":1.75},{"$f":"Input!$C$52","v":1.75}]
["RFi-b",{"$f":"(B272-B275*B273)/(B276*B277)","v":23.969855480425615},{"$f":"(C272-C275*C273)/(C276*C277)","v":24.271622733168883}]
[]
["II. Rating based on flexure"]
["      1.  Operating Load Rating Factor (RFO):"]
[]
[]
[]
["Operating Load Rating Factors, RFO"]
[null,"HL-93 Truck","HL-93 Tandem"]
["σcap",{"$f":"$D$51","v":33},{"$f":"$D$51","v":33}]
["σS ",{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931}]
["σW",{"$f":"$D$86","v":0},{"$f":"$D$86","v":0}]
["σD_bw",{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["σL",{"$f":"$D$234","v":0.13044774367081158},{"$f":"$D$240","v":0.12882589672358197}]
["σL_bw",{"$f":"$D$244","v":4.2106542429635239},{"$f":"$D$247","v":4.1583034966982373}]
["gLL ",{"$f":"Input!$C$53","v":1.35},{"$f":"Input!$C$53","v":1.35}]
["RFo-f",{"$f":"(B287-B291*(B288+B289+B290))/(B294*(B292+B293))","v":3.4475274198664283},{"$f":"(C287-C291*(C288+C289+C290))/(C294*(C292+C293))","v":3.4909298875658998}]
[]
[]
["      2.  Inventory Load Rating Factor (RFi):"]
[]
[]
[]
["Inventory Load Rating Factor, RFi"]
[null,"HL-93 Truck","HL-93 Tandem"]
["σcap",{"$f":"$D$51","v":33},{"$f":"$D$51","v":33}]
["σS ",{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931}]
["σW",{"$f":"$D$86","v":0},{"$f":"$D$86","v":0}]
["σD_bw",{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["σL",{"$f":"$D$234","v":0.13044774367081158},{"$f":"$D$240","v":0.12882589672358197}]
["σL_bw",{"$f":"$D$244","v":4.2106542429635239},{"$f":"$D$247","v":4.1583034966982373}]
["gLL ",{"$f":"Input!$C$52","v":1.75},{"$f":"Input!$C$52","v":1.75}]
["RFi-f",{"$f":"(B304-B308*(B305+B306+B307))/(B311*(B309+B310))","v":2.6595211524683875},{"$f":"(C304-C308*(C305+C306+C307))/(C311*(C309+C310))","v":2.693003056122266}]
[]
["G. Summary"]
["Load Rating Summary:"]
[null,"Load","GVW","Rating Factor","Safe Load"]
["Inventory",{"$f":"B303","v":"HL-93 Truck"},36,{"$f":"MIN(B278,B312)","v":2.6595211524683875},{"$f":"C317*D317","v":95.742761488861944}]
[null,{"$f":"C303","v":"HL-93 Tandem"},25,{"$f":"MIN(C278,C312)","v":2.693003056122266},{"$f":"C318*D318","v":67.325076403056656}]
["Operating",{"$f":"B286","v":"HL-93 Truck"},36,{"$f":"MIN(B264,B295)","v":3.4475274198664283},{"$f":"C319*D319","v":124.11098711519142}]
[null,{"$f":"C286","v":"HL-93 Tandem"},25,{"$f":"MIN(C264,C295)","v":3.4909298875658998},{"$f":"C320*D320","v":87.273247189147497}]

{"sheet":"State Legal Load Rating","index":3,"n_rows":491,"n_cols":9,"rows_kept":491,"cut":false,"hidden":false,"merged":[[29,0,29,2],[35,0,35,2],[36,0,36,2],[17,1,17,2],[0,0,0,5],[2,0,2,1],[4,0,4,5],[5,0,5,5],[6,0,6,5],[7,0,7,2],[8,0,8,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[14,0,14,1],[181,0,181,3],[37,0,37,2],[38,0,38,2],[39,0,39,2],[63,1,63,2],[74,1,75,1],[81,1,82,1],[100,0,100,1],[46,1,46,2],[52,0,52,1],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[91,1,91,2],[92,1,92,2],[40,0,40,2],[18,1,18,2],[19,1,19,2],[25,0,25,1],[27,0,27,2],[28,0,28,2],[486,4,487,4],[113,2,113,3],[114,2,114,3],[115,2,115,3],[114,4,114,5],[115,4,115,5],[483,0,483,5],[471,0,471,5],[484,0,484,3],[404,1,405,1],[410,1,411,1],[450,0,450,5],[422,1,423,1],[428,1,429,1],[456,0,456,5],[229,0,229,3],[116,2,116,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[116,4,116,5],[117,4,117,5],[118,4,118,5],[119,4,119,5],[112,4,113,5],[103,3,103,4],[104,3,104,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[112,1,112,3],[346,0,346,3],[140,0,140,3],[142,0,142,1],[150,0,150,3],[152,0,152,1],[200,0,214,0],[160,0,160,3],[162,0,162,1],[170,0,170,3],[172,0,172,1],[180,0,180,3],[182,0,182,1],[141,0,141,3],[151,0,151,3],[161,0,161,3],[171,0,171,3],[352,0,366,0],[387,0,387,3],[389,0,389,1],[369,0,379,0],[416,1,417,1],[348,0,348,1],[331,0,339,0],[218,0,222,0],[273,0,287,0],[308,0,308,3],[310,0,310,1],[314,0,328,0],[252,0,260,0],[290,0,301,0],[231,0,231,1],[235,0,249,0],[267,0,267,3],[269,0,269,1],[230,0,230,3],[268,0,268,3],[309,0,309,3],[347,0,347,3],[388,0,388,3]]}
["LRFR of Smooth Steel Pipe Structures                                     "]
[]
["A.   Design Dimensions"]
[]
["   1.  For typical structures, use the actual field measured span for calculations."]
["   2.  For those deflected over 5%, use 2 x the top radius (2 Rt) in lieu of span for calculations."]
[]
["Then, Span Length used in Load Rating Calculation =",null,null,{"$f":"'Design Load Rating'!D8","v":8},"ft"]
["Then, Rt used in Load Rating Calculation =",null,null,{"$f":"'Design Load Rating'!D9","v":4},"ft"]
[]
[null,"Inside radius of the steel pipe, ri =",null,{"$f":"'Design Load Rating'!D11","v":48},"in"]
[null,"Outside radius of the steel pipe, ro =",null,{"$f":"'Design Load Rating'!D12","v":49.064999999999998},"in"]
[null,"Mean radius of the steel pipe, r =",null,{"$f":"'Design Load Rating'!D13","v":48.532499999999999},"in"]
[]
["B.   Pipe Properties",null,null," "]
[]
["Mechanical Properties:"]
[null,"Fy = Minimum Yield Point of the Steel",null,{"$f":"'Design Load Rating'!D18","v":33},"ksi"]
[null,"Fu = Minimum Tensile Strength of the Steel",null,{"$f":"'Design Load Rating'!D19","v":45},"ksi"]
[null,"E = Modulus of Elasticity of Steel",null,{"$f":"'Design Load Rating'!D20","v":29000},"ksi"]
[]
["Section Properties:"]
[null,null,"As (in2/ft) =",{"$f":"'Design Load Rating'!D23","v":12.78}]
[null,null,"I (in4/in) =",{"$f":"'Design Load Rating'!D24","v":0.10066246874999997}]
[]
["C.  Capacity:"]
[]
["φ = Resistance Factor for wall area and buckling (LRFD Table 12.5.5-1)",null,null,{"$f":"'Design Load Rating'!D28","v":1}]
["φloss = Section Properties reduction factor on the basis of metal loss from the materials field evaluation =    ",null,null,{"$f":"'Design Load Rating'!D29","v":1}]
["φbkl = Buckling Strength Reduction Factor = ((1-d)/(1+d)2)3 =",null,null,{"$f":"'Design Load Rating'!D30","v":1},"(NRCS NEH 636, 52-34)"]
[]
["Calculate the qb (buckling capacity of the pipe wall) :"]
[]
[" ",null,null,null,"(AWWA Eq 5-7)"]
[]
["Scalar calibration factor to account for some nonlinear effects , Cn =",null,null,0.55000000000000004," "]
["Pipe wall stiffness, EI =",null,null,{"$f":"$D$20*1000*$D$24","v":2919211.5937499991},"lb.in"]
["Factor to account for variability in stiffness of compacted soil, φsoil =",null,null,0.9," "]
["Modulus of soil reaction, E' = ",null,null,{"$f":"Input!$C$35","v":1000},"psi"]
["Modulus correction factor for Poisson's ratio of the soil, kv =",null,null,{"$f":"(1+Input!$C$36)*(1-2*Input!$C$36)/(1-Input!$C$36)","v":0.74285714285714288}]
["Correction factor for depth of fill, RH =",null,null,{"$f":"11.4/(11+2*$D$13/12/Input!$C$39)","v":0.90903912969186085}]
[]
[null,"Therefore,","qb =",{"$f":"$D$28*Input!F15*$D$29*$D$30*1.2*$D$36*$D$37^0.33*($D$38*$D$39*$D$40)^0.67*$D$41/$D$12","v":129.93955789670849},"psi"]
[" "]
["Calculate the σcap (flexural capacity of the pipe wall) :"]
[]
[]
[]
[]
[null,"Therefore,","Tcap = ",{"$f":"$D$28*Input!F15*$D$29*$D$18*$D$23","v":421.73999999999995},"kips/ft"]
[null,null,"σcap = ",{"$f":"$D$28*Input!$F$15*$D$29*$D$18","v":33},"ksi"]
[]
["D. Dead Load Analysis:"]
["Calculate the qs (pressure at crown due to earth cover) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,null,"(AWWA Eq 5-3)"]
[]
[null,"Outside diameter of coated pipe (in) , Dc =",null,{"$f":"2*$D$12","v":98.13}," "]
[null,"Earth load (lb/ft), Wc =",null,{"$f":"Input!$C$40*Input!$C$39*$D$60/12","v":5151.8249999999998}," "]
[null,"Height of Water above Pipe (ft), Hw =",null,{"$f":"IF(Input!$C$42=\"Yes\",Input!$C$44,0)","v":0}]
[null,"Water buoyancy factor, Rw = 1-0.33 (Hw/H)",null,{"$f":"1-0.33*D62/Input!$C$39","v":1}," "]
[null,"Outside diameter of pipe (in), D0 =",null,{"$f":"2*$D$12","v":98.13}," "]
[]
[null,"Therefore,","qs = ",{"$f":"$D$63*$D$61/12/$D$64","v":4.375},"psi"]
[]
["Calculate the qw (pressure at crown due to water) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,"Therefore,","qw = ",{"$f":"Input!$C$43*$D$62/144","v":0},"psi"]
[]
["Calculate the σS (circumferential stress due to earth cover) :"]
[null,"TE = higher value of :","1.   γs H (S/2) =",{"$f":"Input!$C$40*Input!$C$39*$D$8/2/1000","v":2.52},"kips/ft"]
[null,null,"2.   γs H Rt =",{"$f":"Input!$C$40*Input!$C$39*$D$9/1000","v":2.52},"kips/ft"]
[]
[null,"Therefore,","TS = ",{"$f":"MAX($D$75,$D$76)","v":2.52},"kips/ft"]
[null,null,"σS = TS/As =",{"$f":"D78/$D$23","v":0.19718309859154931},"ksi"]
[]
["Calculate the σW (circumferential stress due to water) :",null,null,null,null,null,null," "]
[null,"TE = higher value of :","1.   γw Hw (S/2) =",{"$f":"Input!$C$43*D62*$D$8/2/1000","v":0},"kips/ft"]
[null,null,"2.   γw Hw Rt =",{"$f":"Input!$C$43*D62*$D$9/1000","v":0},"kips/ft"," "]
[]
[null,"Therefore,","TW = ",{"$f":"MAX($D$82,$D$83)","v":0},"kips/ft"]
[null,null,"σW = TW/As =",{"$f":"D85/$D$23","v":0},"ksi"]
[]
["Calculate the σD_bw (Through-Wall Bending Stress)"]
[]
["Ovality",null,null,"(ALA Eq 4-2)"]
[]
[null,"Deflection lag factor, Dl =",null,{"$f":"'Design Load Rating'!D92","v":1}," "]
[null,"Bedding constant, K =",null,{"$f":"'Design Load Rating'!D93","v":0.1}]
[]
[null,"Therefore,","Δy/D0 = ",{"$f":"$D$92*$D$93*$D$66/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":5.0556488097195946E-3}," "]
[]
[null,null,null,"(ALA Eq 4-4)"]
[]
[null,"Therefore,","σD_bw = ",{"$f":"4*$D$20*1000*$D$95*Input!$C$23/(2*$D$12)/1000","v":6.3647697335448763},"ksi"]
[]
["E. Live Load Analysis:"]
[]
["The surface tire contact area for legal loading (per AASHTO LRFD C3.6.1.2.5):"]
[null,"P (kips)","wt (in) = P/0.8","lt (in) = 6.4γ(1+IM/100)"]
["LA Type 3",8,{"$f":"B105/0.8","v":10},{"$f":"6.4*Input!$C$54*(1+$D$137)","v":14.252000000000002}]
["LA Type 3s2",8,{"$f":"B106/0.8","v":10},{"$f":"6.4*Input!$C$54*(1+$D$137)","v":14.252000000000002},null," "]
["Type 3-3",8,{"$f":"B107/0.8","v":10},{"$f":"6.4*Input!$C$54*(1+$D$137)","v":14.252000000000002},null," "]
["LA Type 6",9.25,{"$f":"B108/0.8","v":11.5625},{"$f":"6.4*Input!$C$54*(1+$D$137)","v":14.252000000000002}]
["LA Type 8",9.25,{"$f":"B109/0.8","v":11.5625},{"$f":"6.4*Input!$C$54*(1+$D$137)","v":14.252000000000002}]
[]
["Distribution of wheel loads through earth fills (per AASHTO LRFD 3.6.1.2.6):"]
["1. Single wheel load Distribution:"]
[null,"ww",null,null,"lw"]
[null,"H<2 ft","H≥2 ft"]
[null,"96+1.44S","wt/12+LLDF(H)+0.06Di/12",null,"lt/12+LLDF(H)"]
["LA Type 3",{"$f":"(96+1.44*$D$8)/12","v":8.9599999999999991},{"$f":"C105/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.3508333333333322},null,{"$f":"D105/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["LA Type 3s2",{"$f":"(96+1.44*$D$8)/12","v":8.9599999999999991},{"$f":"C106/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.3508333333333322},null,{"$f":"D106/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["Type 3-3",8.9599999999999991,{"$f":"C107/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.3508333333333322},null,{"$f":"D107/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["LA Type 6",8.9599999999999991,{"$f":"C108/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4810416666666661},null,{"$f":"D108/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["LA Type 8",8.9599999999999991,{"$f":"C109/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4810416666666661},null,{"$f":"D109/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
[]
["2. Overlap Check for Fill Height, H<2 ft:"]
[]
["For parallel to culver spans, overlap requirement is:"]
[" lw≥axial spacing, for minimum axial spacing = 4 ft"]
[null,"LLDF>(4-lt/12)*2"]
["LA Type 3",{"$f":"(4-D105/12)/2","v":1.4061666666666666}]
["LA Type 3s2",{"$f":"(4-D106/12)/2","v":1.4061666666666666}]
["Type 3-3",{"$f":"(4-D107/12)/2","v":1.4061666666666666}]
["LA Type 6",{"$f":"(4-D108/12)/2","v":1.4061666666666666}]
["LA Type 8",{"$f":"(4-D109/12)/2","v":1.4061666666666666},"which is greater than 1.15 specified in LRFD Table 3.6.1.2.6a."]
[]
[null,null,null,"Therefore overlap is not considered for Fill Height, H<2 ft"]
[]
["LA Type 3"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"16000/($B$116*$E$116)","v":247.1519852895139},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B137*C137*(1+D137)/144","v":1.9110297820888416},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E137","v":1.9110297820888416}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 3s2"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"16000/($B$117*$E$117)","v":247.1519852895139},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B147*C147*(1+D147)/144","v":1.9110297820888416},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E147","v":1.9110297820888416}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["Type 3-3"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"16000/($B$118*$E$118)","v":247.1519852895139},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B157*C157*(1+D157)/144","v":1.9110297820888416},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E157","v":1.9110297820888416}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 6"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"18500/($B$119*$E$119)","v":285.76948299100042},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B167*C167*(1+D167)/144","v":2.2096281855402227},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E167","v":2.2096281855402227}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 8"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"18500/($B$120*$E$120)","v":285.76948299100042},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B177*C177*(1+D177)/144","v":2.2096281855402227},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E177","v":2.2096281855402227}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["3. Overlap Check for Fill Height, H≥2 ft:"]
[null,null,"For H<Hint-t"]
[null," ",null,null,null,"(LFRD 3.6.1.2.6b-2)"]
[]
[null,"LRFD 3.6.1.2.6b-1","For H≥Hint-t"]
[]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-3)"]
[]
[null,null,"For H<Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-5)"]
[]
[null,"LRFD 3.6.1.2.6b-4","For H≥Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-6)"]
[]
["LA Type 3"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8000,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C202-$C$105/12-0.06*2*$D$11/12)/Input!$C$47","v":4.0753623188405808},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D202, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D202,$C$105/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$105/12+C202+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.350833333333334}]
[null,"Wheel (lb)",{"$f":"C201","v":8000}," ",null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",9000]
[null,"Spacing, sa (ft)",8,{"$f":"(C220-$D$105/12)/Input!$C$47","v":5.9237681159420292},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D220, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D220,'State Legal Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$105/12+C220+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 2 (lb)",16000]
[null,"Spacing, sa (ft)",4,{"$f":"(C222-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D222, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D222,'State Legal Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$105/12+C222+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C221","v":16000}]
[]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"IF(E222=\"NO\",C201/($C$116*$E$116),IF(E202=\"NO\",(C221+C223)/2/(F202*F222),IF(E220=\"NO\",(C221+C223)/(F202*F222),IF(Input!C22/12<(24-F222),(C221+C223)/(F202*F222),(C219*(F222-12)/$E$116+C221+C223)/(F202*F222)))))","v":213.52503710018374},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B226*C226*(1+D226)/144","v":1.6510193298349711},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E226","v":1.6510193298349711}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 3s2"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8000,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C237-$C$106/12-0.06*2*$D$11/12)/Input!$C$47","v":4.0753623188405808},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D237, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D237,$C$106/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$106/12+C237+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.350833333333334},null,null," "]
[null,"Wheel (lb)",{"$f":"C236","v":8000}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",9000]
[null,"Spacing, sa (ft)",8,{"$f":"(C254-$D$106/12)/Input!$C$47","v":5.9237681159420292},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D254, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D254,'State Legal Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$106/12+C254+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 2 (lb)",16000]
[null,"Spacing, sa (ft)",4,{"$f":"(C256-$D$106/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D256, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D256,'State Legal Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$106/12+C256+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C255","v":16000}]
[null,"Spacing, sa (ft)",8,{"$f":"(C258-$D$106/12)/Input!$C$47","v":5.9237681159420292},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D258, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D258,'State Legal Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$106/12+C258+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 4 (lb)",{"$f":"C257","v":16000}]
[null,"Spacing, sa (ft)",4,{"$f":"(C260-$D$106/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D260, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D260,'State Legal Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$106/12+C260+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",{"$f":"C259","v":16000},null,null,null,null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"IF(E256=\"NO\",C236/($C$117*$E$117),IF(E237=\"NO\",(C255+C257)/2/(F237*F256),IF(E254=\"NO\",(C255+C257)/(F237*F256),IF(Input!C22/12<(24-F256),(C255+C257)/(F237*F256),(C253*(F256-12)/$E$117+C255+C257+C259*(F256-12)/$E$117)/(F237*F256)))))","v":213.52503710018374},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B264*C264*(1+D264)/144","v":1.6510193298349711},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E264","v":1.6510193298349711}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 3-3"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8000,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C275-$C$107/12-0.06*2*$D$11/12)/Input!$C$47","v":4.0753623188405808},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D275, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D275,$C$107/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$107/12+C275+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.350833333333334}]
[null,"Wheel (lb)",{"$f":"C274","v":8000}," ",null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Parallel to culvert spans",null,null,"Hint-p","Overlap","lw"]
[null,"Axle 1 (lb)",12000]
[null,"Spacing, sa (ft)",15,{"$f":"(C293-$D$107/12)/Input!$C$47","v":12.010724637681161},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D293, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D293,'State Legal Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$107/12+C293+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",12000]
[null,"Spacing, sa (ft)",4,{"$f":"(C295-$D$107/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D295, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D295,'State Legal Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$107/12+C295+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",12000]
[null,"Spacing, sa (ft)",15,{"$f":"(C297-$D$107/12)/Input!$C$47","v":12.010724637681161},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D297, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D297,'State Legal Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$107/12+C297+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 4 (lb)",16000]
[null,"Spacing, sa (ft)",16,{"$f":"(C299-$D$107/12)/Input!$C$47","v":12.880289855072464},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D299, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D299,'State Legal Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$107/12+C299+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 5 (lb)",14000]
[null,"Spacing, sa (ft)",4,{"$f":"(C301-$D$107/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D301, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D301,'State Legal Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$107/12+C301+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",14000]
[]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "," "," "]
["Single Lane",{"$f":"IF(E301=\"NO\",C274/($C$118*$E$118),IF(E275=\"NO\",MAX((C300+C302)/2/(F275*F301),C298/2/(F275*F299)),MAX((C300+C302)/(F275*F301),C298/(F275*F299))))","v":186.83440746266075},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B305*C305*(1+D305)/144","v":1.4446419136055997},null,null," "," "]
["Two Lanes",null,null,null,null,null,null," "," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E305","v":1.4446419136055997}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 6"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",9250,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C316-$C$108/12-0.06*2*$D$11/12)/Input!$C$47","v":3.9621376811594207},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D316, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D316,$C$108/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$108/12+C316+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.481041666666666}]
[null,"Wheel (lb)",{"$f":"C315","v":9250}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",6000]
[null,"Spacing, sa (ft)",10,{"$f":"(C333-$D$108/12)/Input!$C$47","v":7.6628985507246377},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D333, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D333,'State Legal Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$108/12+C333+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",18500," "]
[null,"Spacing, sa (ft)",4,{"$f":"(C335-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D335, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D335,'State Legal Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$108/12+C335+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C334","v":18500}]
[null,"Spacing, sa (ft)",22,{"$f":"(C337-$D$108/12)/Input!$C$47","v":18.097681159420294},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D337, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D337,'State Legal Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$108/12+C337+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 4 (lb)",{"$f":"C336","v":18500},null,null,null,null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Spacing, sa (ft)",4,{"$f":"(C339-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D339, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D339,'State Legal Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$108/12+C339+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",{"$f":"C338","v":18500}]
[]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)"]
["Single Lane",{"$f":"IF(E335=\"NO\",C315/($C$119*$E$119),IF(E316=\"NO\",(C334+C336)/2/(F316*F335),(C334+C336)/(F316*F335)))","v":244.50372227421147},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B343*C343*(1+D343)/144","v":1.8905528699284193}]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E343","v":1.8905528699284193}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["LA Type 8"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",9250,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C354-$C$109/12-0.06*2*$D$11/12)/Input!$C$47","v":3.9621376811594207},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D354, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D354,$C$109/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$109/12+C354+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.481041666666666}]
[null,"Wheel (lb)",{"$f":"C353","v":9250}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",6000]
[null,"Spacing, sa (ft)",11,{"$f":"(C371-$D$109/12)/Input!$C$47","v":8.5324637681159423},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D371, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D371,'State Legal Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$109/12+C371+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",18500]
[null,"Spacing, sa (ft)",4,{"$f":"(C373-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D373, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D373,'State Legal Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$109/12+C373+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C372","v":18500}]
[null,"Spacing, sa (ft)",16,{"$f":"(C375-$D$109/12)/Input!$C$47","v":12.880289855072464},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D375, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D375,'State Legal Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$109/12+C375+Input!$C$47*Input!$C$39)","v":7.2251666666666665}]
[null,"Axle 4 (lb)",15000,null,null,null,null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Spacing, sa (ft)",4,{"$f":"(C377-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D377, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D377,'State Legal Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$109/12+C377+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",15000]
[null,"Spacing, sa (ft)",4,{"$f":"(C379-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D379, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'State Legal Load Rating'!D379,'State Legal Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'State Legal Load Rating'!$D$109/12+C379+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",15000]
[]
[]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null,null," "]
["Single Lane",{"$f":"IF(E373=\"NO\",C353/($C$120*$E$120),IF(E354=\"NO\",MAX((C372+C374)/2/(F354*F373),(C376+C378+C380)/2/(F354*(C377+C379+$E$120))),MAX((C372+C374)/(F354*F373),(C376+C378+C380)/(F354*(C377+C379+$E$120)))))","v":244.50372227421147},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B384*C384*(1+D384)/144","v":1.8905528699284193},null,null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E384","v":1.8905528699284193}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["Calculate the qL (pressure at crown due to live load) :"]
[" "]
["LA Type 3","qL=",{"$f":"IF(Input!$C$39<2,'State Legal Load Rating'!E141,'State Legal Load Rating'!E230)","v":1.6510193298349711},"psi","  "]
[]
["LA Type 3s2","qL=",{"$f":"IF(Input!$C$39<2,'State Legal Load Rating'!E151,'State Legal Load Rating'!E268)","v":1.6510193298349711},"psi"]
[]
["Type 3-3","qL=",{"$f":"IF(Input!$C$39<2,'State Legal Load Rating'!E161,'State Legal Load Rating'!E309)","v":1.4446419136055997},"psi","  "]
[]
["LA Type 6","qL=",{"$f":"IF(Input!$C$39<2,'State Legal Load Rating'!E171,'State Legal Load Rating'!E347)","v":1.8905528699284193},"psi","  "]
[]
["LA Type 8","qL=",{"$f":"IF(Input!$C$39<2,'State Legal Load Rating'!E181,'State Legal Load Rating'!E388)","v":1.8905528699284193},"psi","  "]
[]
["Calculate the σL (circumferential stress due to live load plus dynamic load allowance) :"]
["LA Type 3","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E230*$D$8/2*144/1000","v":0.95098713398494339},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E230*$D$9*144/1000","v":0.95098713398494339},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D405,D406)","v":0.95098713398494339},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D408/$D$23","v":7.4412138809463499E-2},"ksi"]
[]
["LA Type 3s2","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E268*$D$8/2*144/1000","v":0.95098713398494339},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E268*$D$9*144/1000","v":0.95098713398494339},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D411,D412)","v":0.95098713398494339},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D414/$D$23","v":7.4412138809463499E-2},"ksi"]
[]
["Type 3-3","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E309*$D$8/2*144/1000","v":0.83211374223682533},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E309*$D$9*144/1000","v":0.83211374223682533},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D417,D418)","v":0.83211374223682533},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D420/$D$23","v":6.5110621458280546E-2},"ksi"]
[]
["LA Type 6","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E347*$D$8/2*144/1000","v":1.0889584530787695},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E347*$D$9*144/1000","v":1.0889584530787695},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D423,D424)","v":1.0889584530787695},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D426/$D$23","v":8.5208016672830164E-2},"ksi"]
[]
["LA Type 8","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E388*$D$8/2*144/1000","v":1.0889584530787695},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E388*$D$9*144/1000","v":1.0889584530787695},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D429,D430)","v":1.0889584530787695},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D432/$D$23","v":8.5208016672830164E-2},"ksi"]
[]
["Calculate the σL_bw (Through-Wall Bending Stress)"]
["LA Type 3"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C394/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":1.9078797507895351E-3}," "]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D436*Input!$C$23/(2*$D$12)/1000","v":2.4019103680071248},"ksi"]
[]
["LA Type 3s2",null,"Δy/D0 = ",{"$f":"$D$92*$D$93*C396/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":1.9078797507895351E-3}]
[null,null,"σL_bw = ",{"$f":"4*$D$20*1000*D439*Input!$C$23/(2*$D$12)/1000","v":2.4019103680071248},"ksi"]
[]
["Type 3-3"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C398/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":1.6693947819408428E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D442*Input!$C$23/(2*$D$12)/1000","v":2.101671572006234},"ksi"]
[]
["LA Type 6"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C400/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.1846791695007035E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D445*Input!$C$23/(2*$D$12)/1000","v":2.7503848425569846},"ksi"]
[]
["LA Type 8"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C402/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.1846791695007035E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D448*Input!$C$23/(2*$D$12)/1000","v":2.7503848425569846},"ksi"]
[]
["F.   Load Rating Analysis"]
["I. Rating based on buckling"]
["      Load Rating Factor (RFb):"]
[]
[]
[]
["Load Rating Factors, RFO"]
[null,"LA Type 3","LA Type 3s2","LA Type 3-3","LA Type 6","LA Type 8"]
["qa",{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849}]
["qs ",{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375}]
["qw",{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["ql",{"$f":"$C$394","v":1.6510193298349711},{"$f":"$C$396","v":1.6510193298349711},{"$f":"$C$398","v":1.4446419136055997},{"$f":"$C$400","v":1.8905528699284193},{"$f":"$C$402","v":1.8905528699284193}]
["gLL ",{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2}]
["RFb",{"$f":"(B459-B462*B460)/(B463*B464)","v":36.767682153316748},{"$f":"(C459-C462*C460)/(C463*C464)","v":36.767682153316748},{"$f":"(D459-D462*D460)/(D463*D464)","v":42.020208175219146},{"$f":"(E459-E462*E460)/(E463*E464)","v":32.109207266259972},{"$f":"(F459-F462*F460)/(F463*F464)","v":32.109207266259972}]
[]
["II. Rating based on flexure"]
["      Load Rating Factor (RFt):"]
[]
[]
[]
["Load Rating Factors, RFO"]
[null,"LA Type 3","LA Type 3s2","Type 3-3","LA Type 6","LA Type 8"]
["σcap",{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33}," "]
["σS ",{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931}]
["σW",{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0}]
["σD_bw",{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["σL",{"$f":"$D$409","v":7.4412138809463499E-2},{"$f":"$D$415","v":7.4412138809463499E-2},{"$f":"$D$421","v":6.5110621458280546E-2},{"$f":"$D$427","v":8.5208016672830164E-2},{"$f":"$D$433","v":8.5208016672830164E-2}]
["σL_bw",{"$f":"D437","v":2.4019103680071248},{"$f":"D440","v":2.4019103680071248},{"$f":"D443","v":2.101671572006234},{"$f":"D446","v":2.7503848425569846},{"$f":"D449","v":2.7503848425569846}]
["gLL ",{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2}]
["RFf",{"$f":"(B474-B478*(B475+B476+B477))/(B481*(B479+B480))","v":4.0794750929488721},{"$f":"(C474-C478*(C475+C476+C477))/(C481*(C479+C480))","v":4.0794750929488721},4.6622572490844254,3.5626045381602673,3.5626045381602673]
[]
["G. Summary"]
["Load Rating Summary:"]
["Load","GVW","Rating Factor","Safe Load"]
[{"$f":"B473","v":"LA Type 3"},20.5,{"$f":"MIN(B465,B482)","v":4.0794750929488721},{"$f":"B487*C487","v":83.629239405451884}]
[{"$f":"C473","v":"LA Type 3s2"},36.5,{"$f":"MIN(C465,C482)","v":4.0794750929488721},{"$f":"B488*C488","v":148.90084089263382}]
[{"$f":"D473","v":"Type 3-3"},40,{"$f":"MIN(D465,D482)","v":4.6622572490844254},{"$f":"B489*C489","v":186.49028996337702}]
[{"$f":"E473","v":"LA Type 6"},40,{"$f":"MIN(E465,E482)","v":3.5626045381602673},{"$f":"B490*C490","v":142.50418152641069}]
[{"$f":"F473","v":"LA Type 8"},44,{"$f":"MIN(F465,F482)","v":3.5626045381602673},{"$f":"B491*C491","v":156.75459967905175}]

{"sheet":"SHV Load Rating","index":4,"n_rows":500,"n_cols":9,"rows_kept":500,"cut":false,"hidden":false,"merged":[[240,0,240,3],[17,1,17,2],[0,0,0,5],[2,0,2,1],[4,0,4,5],[5,0,5,5],[6,0,6,5],[7,0,7,2],[8,0,8,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[14,0,14,1],[40,0,40,2],[18,1,18,2],[19,1,19,2],[25,0,25,1],[27,0,27,2],[28,0,28,2],[29,0,29,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[104,3,104,4],[46,1,46,2],[52,0,52,1],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[74,1,75,1],[81,1,82,1],[100,0,100,1],[103,3,103,4],[91,1,91,2],[92,1,92,2],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[112,1,112,3],[112,4,113,5],[113,2,113,3],[114,2,114,3],[114,4,114,5],[115,2,115,3],[115,4,115,5],[116,2,116,3],[116,4,116,5],[140,0,140,3],[142,0,142,1],[150,0,150,3],[152,0,152,1],[200,0,214,0],[160,0,160,3],[162,0,162,1],[170,0,170,3],[172,0,172,1],[180,0,180,3],[182,0,182,1],[141,0,141,3],[151,0,151,3],[161,0,161,3],[171,0,171,3],[181,0,181,3],[117,2,117,3],[117,4,117,5],[118,2,118,3],[118,4,118,5],[119,2,119,3],[119,4,119,5],[493,0,493,3],[495,4,496,4],[281,0,295,0],[314,0,314,3],[316,0,316,1],[320,0,334,0],[299,0,307,0],[337,0,347,0],[377,0,389,0],[413,1,414,1],[354,0,354,3],[356,0,356,1],[360,0,374,0],[396,0,396,3],[398,0,398,1],[419,1,420,1],[218,0,232,0],[465,0,465,5],[480,0,480,5],[492,0,492,5],[239,0,239,3],[241,0,241,1],[245,0,259,0],[262,0,268,0],[275,0,275,3],[277,0,277,1],[425,1,426,1],[431,1,432,1],[437,1,438,1],[459,0,459,5],[397,0,397,3],[355,0,355,3],[315,0,315,3],[276,0,276,3]]}
["LRFR of Smooth Steel Pipe Structures                                     "]
[]
["A.   Design Dimensions"]
[]
["   1.  For typical structures, use the actual field measured span for calculations."]
["   2.  For those deflected over 5%, use 2 x the top radius (2 Rt) in lieu of span for calculations."]
[]
["Then, Span Length used in Load Rating Calculation =",null,null,{"$f":"'Design Load Rating'!D8","v":8},"ft"]
["Then, Rt used in Load Rating Calculation =",null,null,{"$f":"'Design Load Rating'!D9","v":4},"ft"]
[]
[null,"Inside radius of the steel pipe, ri =",null,{"$f":"'Design Load Rating'!D11","v":48},"in"]
[null,"Outside radius of the steel pipe, ro =",null,{"$f":"'Design Load Rating'!D12","v":49.064999999999998},"in"]
[null,"Mean radius of the steel pipe, r =",null,{"$f":"'Design Load Rating'!D13","v":48.532499999999999},"in"]
[]
["B.   Pipe Properties",null,null," "]
[]
["Mechanical Properties:"]
[null,"Fy = Minimum Yield Point of the Steel",null,{"$f":"'Design Load Rating'!D18","v":33},"ksi"]
[null,"Fu = Minimum Tensile Strength of the Steel",null,{"$f":"'Design Load Rating'!D19","v":45},"ksi"]
[null,"E = Modulus of Elasticity of Steel",null,{"$f":"'Design Load Rating'!D20","v":29000},"ksi"]
[]
["Section Properties:"]
[null,null,"As (in2/ft) =",{"$f":"'Design Load Rating'!D23","v":12.78}]
[null,null,"I (in4/in) =",{"$f":"'Design Load Rating'!D24","v":0.10066246874999997}]
[]
["C.  Capacity:"]
[]
["φ = Resistance Factor for wall area and buckling (LRFD Table 12.5.5-1)",null,null,{"$f":"'Design Load Rating'!D28","v":1}]
["φloss = Section Properties reduction factor on the basis of metal loss from the materials field evaluation =    ",null,null,{"$f":"'Design Load Rating'!D29","v":1}]
["φbkl = Buckling Strength Reduction Factor = ((1-d)/(1+d)2)3 =",null,null,{"$f":"'Design Load Rating'!D30","v":1},"(NRCS NEH 636, 52-34)"]
[]
["Calculate the qb (buckling capacity of the pipe wall) :"]
[]
[" ",null,null,null,"(AWWA Eq 5-7)"]
[]
["Scalar calibration factor to account for some nonlinear effects , Cn =",null,null,0.55000000000000004," "]
["Pipe wall stiffness, EI =",null,null,{"$f":"$D$20*1000*$D$24","v":2919211.5937499991},"lb.in"]
["Factor to account for variability in stiffness of compacted soil, φsoil =",null,null,0.9," "]
["Modulus of soil reaction, E' = ",null,null,{"$f":"Input!$C$35","v":1000},"psi"]
["Modulus correction factor for Poisson's ratio of the soil, kv =",null,null,{"$f":"(1+Input!$C$36)*(1-2*Input!$C$36)/(1-Input!$C$36)","v":0.74285714285714288}]
["Correction factor for depth of fill, RH =",null,null,{"$f":"11.4/(11+2*$D$13/12/Input!$C$39)","v":0.90903912969186085}]
[]
[null,"Therefore,","qb =",{"$f":"$D$28*Input!F15*$D$29*$D$30*1.2*$D$36*$D$37^0.33*($D$38*$D$39*$D$40)^0.67*$D$41/$D$12","v":129.93955789670849},"psi"]
[" "]
["Calculate the σcap (flexural capacity of the pipe wall) :"]
[]
[]
[]
[]
[null,"Therefore,","Tcap = ",{"$f":"$D$28*Input!F15*$D$29*$D$18*$D$23","v":421.73999999999995},"kips/ft"]
[null,null,"σcap = ",{"$f":"$D$28*Input!$F$15*$D$29*$D$18","v":33},"ksi"]
[]
["D. Dead Load Analysis:"]
["Calculate the qs (pressure at crown due to live load) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,null,"(AWWA Eq 5-3)"]
[]
[null,"Outside diameter of coated pipe (in) , Dc =",null,{"$f":"2*$D$12","v":98.13}," "]
[null,"Earth load (lb/ft), Wc =",null,{"$f":"Input!$C$40*Input!$C$39*$D$60/12","v":5151.8249999999998}," "]
[null,"Height of Water above Pipe (ft), Hw =",null,{"$f":"IF(Input!$C$42=\"Yes\",Input!$C$44,0)","v":0}]
[null,"Water buoyancy factor, Rw = 1-0.33 (Hw/H)",null,{"$f":"1-0.33*D62/Input!$C$39","v":1}," "]
[null,"Outside diameter of pipe (in), D0 =",null,{"$f":"2*$D$12","v":98.13}," "]
[]
[null,"Therefore,","qs = ",{"$f":"$D$63*$D$61/12/$D$64","v":4.375},"psi"]
[]
["Calculate the qw (pressure at crown due to water) :"]
[]
[null,null,"(AWWA Eq 5-9)"]
[]
[null,"Therefore,","qw = ",{"$f":"Input!$C$43*$D$62/144","v":0},"psi"]
[]
["Calculate the σS (circumferential stress due to earth cover) :"]
[null,"TE = higher value of :","1.   γs H (S/2) =",{"$f":"Input!$C$40*Input!$C$39*$D$8/2/1000","v":2.52},"kips/ft"]
[null,null,"2.   γs H Rt =",{"$f":"Input!$C$40*Input!$C$39*$D$9/1000","v":2.52},"kips/ft"]
[]
[null,"Therefore,","TS = ",{"$f":"MAX($D$75,$D$76)","v":2.52},"kips/ft"]
[null,null,"σS = TS/As =",{"$f":"D78/$D$23","v":0.19718309859154931},"ksi"]
[]
["Calculate the σW (circumferential stress due to water) :",null,null,null,null,null,null," "]
[null,"TE = higher value of :","1.   γw Hw (S/2) =",{"$f":"Input!$C$43*D62*$D$8/2/1000","v":0},"kips/ft"]
[null,null,"2.   γw Hw Rt =",{"$f":"Input!$C$43*D62*$D$9/1000","v":0},"kips/ft"," "]
[]
[null,"Therefore,","TW = ",{"$f":"MAX($D$82,$D$83)","v":0},"kips/ft"]
[null,null,"σW = TW/As =",{"$f":"D85/$D$23","v":0},"ksi"]
[]
["Calculate the σD_bw (Through-Wall Bending Stress)"]
[]
["Ovality",null,null,"(ALA Eq 4-2)"]
[]
[null,"Deflection lag factor, Dl =",null,{"$f":"'Design Load Rating'!D92","v":1}," "]
[null,"Bedding constant, K =",null,{"$f":"'Design Load Rating'!D93","v":0.1}]
[]
[null,"Therefore,","Δy/D0 = ",{"$f":"$D$92*$D$93*$D$66/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":5.0556488097195946E-3}," "]
[]
[null,null,null,"(ALA Eq 4-4)"]
[]
[null,"Therefore,","σD_bw = ",{"$f":"4*$D$20*1000*$D$95*Input!$C$23/(2*$D$12)/1000","v":6.3647697335448763},"ksi"]
[]
["E. Live Load Analysis:"]
[]
["The surface tire contact area for legal loading (per AASHTO LRFD C3.6.1.2.5):"]
[null,"P (kips)","wt (in) = P/0.8","lt (in) = 6.4γ(1+IM/100)"]
["NRL",8.5,{"$f":"B105/0.8","v":10.625},{"$f":"6.4*Input!$C$55*(1+$D$137)","v":14.252000000000002}]
["SU4",8.5,{"$f":"B106/0.8","v":10.625},{"$f":"6.4*Input!$C$55*(1+$D$137)","v":14.252000000000002},null," "]
["SU5",8.5,{"$f":"B107/0.8","v":10.625},{"$f":"6.4*Input!$C$55*(1+$D$137)","v":14.252000000000002},null," "]
["SU6",8.5,{"$f":"B108/0.8","v":10.625},{"$f":"6.4*Input!$C$55*(1+$D$137)","v":14.252000000000002}]
["SU7",8.5,{"$f":"B109/0.8","v":10.625},{"$f":"6.4*Input!$C$55*(1+$D$137)","v":14.252000000000002}]
[]
["Distribution of wheel loads through earth fills (per AASHTO LRFD 3.6.1.2.6):",null,null,null," "]
["1. Single wheel load Distribution:"]
[null,"ww",null,null,"lw"]
[null,"H<2 ft","H≥2 ft"]
[null,"96+1.44S","wt/12+LLDF(H)+0.06Di/12",null,"lt/12+LLDF(H)"]
["NRL",{"$f":"(96+1.44*$D$8)/12","v":8.9599999999999991},{"$f":"C105/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4029166666666661},null,{"$f":"D105/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["SU4",{"$f":"(96+1.44*$D$8)/12","v":8.9599999999999991},{"$f":"C106/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4029166666666661},null,{"$f":"D106/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["SU5",8.9599999999999991,{"$f":"C107/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4029166666666661},null,{"$f":"D107/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["SU6",8.9599999999999991,{"$f":"C108/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4029166666666661},null,{"$f":"D108/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
["SU7",8.9599999999999991,{"$f":"C109/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12","v":7.4029166666666661},null,{"$f":"D109/12+Input!$C$47*Input!$C$39","v":7.2251666666666665}]
[]
["2. Overlap Check for Fill Height, H<2 ft:"]
[]
["For parallel to culver spans, overlap requirement is:"]
[" lw≥axial spacing, for minimum axial spacing = 4 ft"]
[null,"LLDF>(4-lt/12)*2"]
["NRL",{"$f":"(4-D105/12)/2","v":1.4061666666666666}]
["SU4",{"$f":"(4-D106/12)/2","v":1.4061666666666666}]
["SU5",{"$f":"(4-D107/12)/2","v":1.4061666666666666}]
["SU6",{"$f":"(4-D108/12)/2","v":1.4061666666666666}]
["SU7",{"$f":"(4-D109/12)/2","v":1.4061666666666666},"which is greater than 1.15 specified in LRFD Table 3.6.1.2.6a."]
[]
[null,null,null,"Therefore overlap is not considered for Fill Height, H<2 ft"]
[]
["NRL"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"17000/($B$116*$E$116)","v":262.5989843701085},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B137*C137*(1+D137)/144","v":2.0304691434693938},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E137","v":2.0304691434693938}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU4"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"17000/($B$117*$E$117)","v":262.5989843701085},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B147*C147*(1+D147)/144","v":2.0304691434693938},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E147","v":2.0304691434693938}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU5"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"17000/($B$118*$E$118)","v":262.5989843701085},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B157*C157*(1+D157)/144","v":2.0304691434693938},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E157","v":2.0304691434693938}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU6"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"17000/($B$119*$E$119)","v":262.5989843701085},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B167*C167*(1+D167)/144","v":2.0304691434693938},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E167","v":2.0304691434693938}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU7"]
[null,"Pressure (psf)","Multi-presence Factor (MBE 6A.5.12.10.3)","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"17000/($B$120*$E$120)","v":262.5989843701085},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B177*C177*(1+D177)/144","v":2.0304691434693938},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E177","v":2.0304691434693938}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["3. Overlap Check for Fill Height, H≥2 ft:"]
[null,null,"For H<Hint-t"]
[null," ",null,null,null,"(LFRD 3.6.1.2.6b-2)"]
[]
[null,"LRFD 3.6.1.2.6b-1","For H≥Hint-t"]
[]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-3)"]
[]
[null,null,"For H<Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-5)"]
[]
[null,"LRFD 3.6.1.2.6b-4","For H≥Hint-p"]
[null,null,null,null,null,"(LFRD 3.6.1.2.6b-6)"]
[]
["NRL"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8500,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C202-$C$105/12-0.06*2*$D$11/12)/Input!$C$47","v":4.030072463768116},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D202, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D202,$C$105/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$105/12+C202+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.402916666666666}]
[null,"Wheel (lb)",{"$f":"C201","v":8500}," ",null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",6000]
[null,"Spacing, sa (ft)",6,{"$f":"(C220-$D$105/12)/Input!$C$47","v":4.1846376811594208},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D220, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D220,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C220+Input!$C$47*Input!$C$39)","v":13.225166666666667},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",8000," "," "," "]
[null,"Spacing, sa (ft)",4,{"$f":"(C222-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D222, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D222,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C222+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C224-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D224, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D224,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C224+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 4 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C226-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D226, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D226,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C226+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C228-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D228, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D228,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C228+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C230-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D230, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D230,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C230+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 7 (lb)",8000,null,null,null,null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Spacing, sa (ft)",4,{"$f":"(C232-$D$105/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D232, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D232,'SHV Load Rating'!$D$105/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$105/12+C232+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 8 (lb)",8000]
[]
[null,"Pressure (psf)","Multi-presence Factor","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"IF(E226=\"NO\",C201/($C$116*$E$116),IF(E202=\"NO\",IF(Input!C22/12<=(16-F226),((C225+C227)/2)/(F202*F226),((C223*(F226-8)/$E$116+C225+C227+C229*(F226-8)/$E$116)/2)/(F202*F226)),IF(Input!C22/12<=(16-F226),(C225+C227)/(F202*F226),(C223*(F226-8)/$E$116+C225+C227+C229*(F226-8)/$E$116)/(F202*F226))))","v":273.46015367566838},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B236*C236*(1+D236)/144","v":2.1144499295711947},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes",null,null,null,null," "]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E236","v":2.1144499295711947}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU4"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8500,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C247-$C$106/12-0.06*2*$D$11/12)/Input!$C$47","v":4.030072463768116},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D247, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D247,$C$106/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$106/12+C247+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.402916666666666},null,null," "]
[null,"Wheel (lb)",{"$f":"C246","v":8500}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",12000]
[null,"Spacing, sa (ft)",10,{"$f":"(C264-$D$106/12)/Input!$C$47","v":7.6628985507246377},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D264, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D264,'SHV Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$106/12+C264+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C266-$D$106/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D266, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D266,'SHV Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$106/12+C266+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C268-$D$106/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D268, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D268,'SHV Load Rating'!$D$106/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$106/12+C268+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 4 (lb)",{"$f":"C267","v":17000}]
[]
[null,"Pressure (psf)","Multi-presence Factor","IM","Pressure (psi)",null," "]
["Single Lane",{"$f":"IF(E268=\"NO\",C246/($C$117*$E$117),IF(E247=\"NO\",IF(Input!C22/12<=(16-F268), ((C267+C269)/2)/(F247*F268),((C265*(F268-8)/$E$117+C267+C269)/2)/(F247*F268)),IF(Input!C22/12<=(16-F268),(C267+C269)/(F247*F268),(C265*(F268-8)/$E$117+C267+C269)/(F247*F268))))","v":249.72444709596894},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B272*C272*(1+D272)/144","v":1.9309205837737358},null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E272","v":1.9309205837737358}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU5"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8500,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C283-$C$107/12-0.06*2*$D$11/12)/Input!$C$47","v":4.030072463768116},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D283, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D283,$C$107/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$107/12+C283+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.402916666666666}]
[null,"Wheel (lb)",{"$f":"C282","v":8500}," ",null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lw"]
["Parallel to culvert spans","Axle 1 (lb)",12000]
[null,"Spacing, sa (ft)",10,{"$f":"(C301-$D$107/12)/Input!$C$47","v":7.6628985507246377},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D301, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D301,'SHV Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$107/12+C301+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C303-$D$107/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D303, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D303,'SHV Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$107/12+C303+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C305-$D$107/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D305, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D305,'SHV Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$107/12+C305+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 4 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C307-$D$107/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D307, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D307,'SHV Load Rating'!$D$107/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$107/12+C307+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",17000]
[]
[null,"Pressure (psf)","Multi-presence Factor","IM","Pressure (psi)",null," ",null," "]
["Single Lane",{"$f":"IF(E307=\"NO\",C282/($C$118*$E$118),IF(E283=\"NO\",IF(Input!C22/12<=(16-F307), ((C306+C308)/2)/(F283*F307), ((C304*(F307-8)/$E$118+C306+C308)/2)/(F283*F307)),IF(Input!C22/12<=(16-F307),(C306+C308)/(F283*F307), (C304*(F307-8)/$E$118+C306+C308)/(F283*F307))))","v":249.72444709596894},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B311*C311*(1+D311)/144","v":1.9309205837737358},null,null,null," "]
["Two Lanes",null,null,null,null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E311","v":1.9309205837737358}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU6"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8500,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C322-$C$108/12-0.06*2*$D$11/12)/Input!$C$47","v":4.030072463768116},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D322, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D322,$C$108/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$108/12+C322+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.402916666666666}]
[null,"Wheel (lb)",{"$f":"C321","v":8500}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lt"]
["Parallel to culvert spans","Axle 1 (lb)",11500]
[null,"Spacing, sa (ft)",10,{"$f":"(C339-$D$108/12)/Input!$C$47","v":7.6628985507246377},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D339, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D339,'SHV Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$108/12+C339+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",8000," "]
[null,"Spacing, sa (ft)",4,{"$f":"(C341-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D341, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D341,'SHV Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$108/12+C341+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C340","v":8000}]
[null,"Spacing, sa (ft)",4,{"$f":"(C343-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D343, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D343,'SHV Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$108/12+C343+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 4 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C345-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D345, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D345,'SHV Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$108/12+C345+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",{"$f":"C344","v":17000}]
[null,"Spacing, sa (ft)",4,{"$f":"(C347-$D$108/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D347, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D347,'SHV Load Rating'!$D$108/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$108/12+C347+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",8000]
[]
[null,"Pressure (psf)","Multi-presence Factor","IM","Pressure (psi)"]
["Single Lane",{"$f":"IF(E345=\"NO\",C321/($C$119*$E$119),IF(E322=\"NO\",IF(Input!C22/12<=(16-F345),((C344+C346)/2)/(F322*F345),((C342*(F345-8)/$E$119+C344+C346+C348*(F345-8)/$E$119)/2)/(F322*F345)),IF(Input!C22/12<=(16-F345),(C344+C346)/(F322*F345),(C342*(F345-8)/$E$119)+C344+C346+C348*(F345-8)/$E$119)/(F322*F345)))","v":273.46015367566838},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B351*C351*(1+D351)/144","v":2.1144499295711947}]
["Two Lanes",null,null,null,null," "]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E351","v":2.1144499295711947}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["SU7"]
[null,null,null,"Hint-t","Overlap","ww"]
["Transverse to culvert spans","Wheel (lb)",8500,null,null,null,null,"only the single-lane loaded condition needs to be chedked for legal load (MBE 6A.5.12.10.3)"]
[null,"Spacing, sw (ft)",6,{"$f":"(C362-$C$109/12-0.06*2*$D$11/12)/Input!$C$47","v":4.030072463768116},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D362, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<D362,$C$109/12+Input!$C$47*Input!$C$39+0.06*2*$D$11/12,$C$109/12+C362+Input!$C$47*Input!$C$39+0.06*2*$D$11/12)","v":13.402916666666666}]
[null,"Wheel (lb)",{"$f":"C361","v":8500}," ",null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hint-p","Overlap","lt"]
["Parallel to culvert spans","Axle 1 (lb)",11500]
[null,"Spacing, sa (ft)",10,{"$f":"(C379-$D$109/12)/Input!$C$47","v":7.6628985507246377},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D379, \"NO\", \"YES\")","v":"NO"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D379,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C379+Input!$C$47*Input!$C$39)","v":7.2251666666666665},null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[null,"Axle 2 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C381-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D381, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D381,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C381+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 3 (lb)",{"$f":"C380","v":8000}]
[null,"Spacing, sa (ft)",4,{"$f":"(C383-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D383, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D383,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C383+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 4 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C385-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D385, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D385,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C385+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 5 (lb)",17000]
[null,"Spacing, sa (ft)",4,{"$f":"(C387-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D387, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D387,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C387+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",8000]
[null,"Spacing, sa (ft)",4,{"$f":"(C389-$D$109/12)/Input!$C$47","v":2.4455072463768115},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D389, \"NO\", \"YES\")","v":"YES"},{"$f":"IF(Input!$C$39<'SHV Load Rating'!D389,'SHV Load Rating'!$D$109/12+Input!$C$47*Input!$C$39,'SHV Load Rating'!$D$109/12+C389+Input!$C$47*Input!$C$39)","v":11.225166666666667}]
[null,"Axle 6 (lb)",8000,null,null,null,null,"Gray shaded areas are axles not considered in analysis because of axle configuration."]
[]
[null,"Pressure (psf)","Multi-presence Factor","IM","Pressure (psi)",null,null," "]
["Single Lane",{"$f":"IF(E381=\"NO\",C361/($C$120*$E$120),IF(E362=\"NO\",IF(Input!C22/12<=(16-F385),((C384+C386)/2)/(F362*F385),((C382*(F385-8)/$E$120+C384+C386+C388*(F385-8)/$E$120)/2)/(F362*F385)),IF(Input!C22/12<=(16-F385),(C384+C386)/(F362*F385),(C382*(F385-8)/$E$120+C384+C386+C388*(F385-8)/$E$120)/(F362*F385))))","v":273.46015367566838},1,{"$f":"IF(33*(1-0.125*Input!$C$39)/100>0,33*(1-0.125*Input!$C$39)/100,0)","v":0.1134375},{"$f":"B393*C393*(1+D393)/144","v":2.1144499295711947},null,null," "]
["Two Lanes"]
["Three Lanes"]
["> Three Lanes"]
["Control live load pressure at crown for Load Rating (maximum) = ",null,null,null,{"$f":"E393","v":2.1144499295711947}," "]
["           Only the single-lane loaded condition needs to be checked (MBE 6A.5.12.10.3)"]
["Live load Dynamic Load Allowance,   IM =",null,"33(1.0-0.125 DE) ≥ 0%","(LRFD 3.6.2.2-1)"]
[]
["Calculate the qL (pressure at crown due to live load) :"]
[" "]
["NRL","qL=",{"$f":"IF(Input!$C$39<2,'SHV Load Rating'!E141,'SHV Load Rating'!E240)","v":2.1144499295711947},"psi","  "]
[]
["SU4","qL=",{"$f":"IF(Input!$C$39<2,'SHV Load Rating'!E151,'SHV Load Rating'!E276)","v":1.9309205837737358},"psi"]
[]
["Su5","qL=",{"$f":"IF(Input!$C$39<2,'SHV Load Rating'!E161,'SHV Load Rating'!E315)","v":1.9309205837737358},"psi","  "]
[]
["SU6","qL=",{"$f":"IF(Input!$C$39<2,'SHV Load Rating'!E171,'SHV Load Rating'!E355)","v":2.1144499295711947},"psi","  "]
[]
["SU7","qL=",{"$f":"IF(Input!$C$39<2,'SHV Load Rating'!E181,'SHV Load Rating'!E397)","v":2.1144499295711947},"psi","  "]
[]
["Calculate the TL (pipe wall thrust due to live load plus dynamic load allowance) :"]
["NRL","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E240*$D$8/2*144/1000","v":1.217923159433008},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E240*$D$9*144/1000","v":1.217923159433008},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D414,D415)","v":1.217923159433008},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D417/$D$23","v":9.5299151755321443E-2},"ksi"]
[]
["SU4","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E276*$D$8/2*144/1000","v":1.1122102562536718},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E276*$D$9*144/1000","v":1.1122102562536718},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D420,D421)","v":1.1122102562536718},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D423/$D$23","v":8.702740659261908E-2},"ksi"]
[]
["SU5","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E315*$D$8/2*144/1000","v":1.1122102562536718},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E315*$D$9*144/1000","v":1.1122102562536718},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D426,D427)","v":1.1122102562536718},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D429/$D$23","v":8.702740659261908E-2},"ksi"]
[]
["SU6","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E355*$D$8/2*144/1000","v":1.217923159433008},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E355*$D$9*144/1000","v":1.217923159433008},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D432,D433)","v":1.217923159433008},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D435/$D$23","v":9.5299151755321443E-2},"ksi"]
[]
["SU7","Tl = higher value of :","1.   ql(S/2) =",{"$f":"E397*$D$8/2*144/1000","v":1.217923159433008},"kips/ft"]
[null,null,"2.   qlRt =",{"$f":"E397*$D$9*144/1000","v":1.217923159433008},"kips/ft"]
[]
[null,"Therefore,","TL = ",{"$f":"MAX(D438,D439)","v":1.217923159433008},"kips/ft"]
[null,null,"σL = TL/As =",{"$f":"D441/$D$23","v":9.5299151755321443E-2},"ksi"]
[]
["Calculate the σL_bw (Through-Wall Bending Stress)"]
["LA Type 3"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C403/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.4434094330624671E-3}," "]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D445*Input!$C$23/(2*$D$12)/1000","v":3.0761112948184772},"ksi"]
[]
["LA Type 3s2",null,"Δy/D0 = ",{"$f":"$D$92*$D$93*C405/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.2313271659471436E-3}]
[null,null,"σL_bw = ",{"$f":"4*$D$20*1000*D448*Input!$C$23/(2*$D$12)/1000","v":2.8091119747387152},"ksi"]
[]
["Type 3-3"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C407/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.2313271659471436E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D451*Input!$C$23/(2*$D$12)/1000","v":2.8091119747387152},"ksi"]
[]
["LA Type 6"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C409/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.4434094330624671E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D454*Input!$C$23/(2*$D$12)/1000","v":3.0761112948184772},"ksi"]
[]
["LA Type 8"," ","Δy/D0 = ",{"$f":"$D$92*$D$93*C411/($D$20*1000*$D$24/$D$13^3+0.061*Input!$C$35)","v":2.4434094330624671E-3}]
[null," ","σL_bw = ",{"$f":"4*$D$20*1000*D457*Input!$C$23/(2*$D$12)/1000","v":3.0761112948184772},"ksi"]
[]
["F.   Load Rating Analysis"]
["I. Rating based on buckling"]
["      Load Rating Factor (RFb):"]
[]
[]
[]
["Load Rating Factors, RFO"]
[null,"NRL","SU4","SU5","SU6","SU7"]
["qb",{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849},{"$f":"$D$43","v":129.93955789670849}]
["qs ",{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375},{"$f":"$D$66","v":4.375}]
["qw",{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0},{"$f":"$D$72","v":0}]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["qL",{"$f":"$C$403","v":2.1144499295711947},{"$f":"$C$405","v":1.9309205837737358},{"$f":"$C$407","v":1.9309205837737358},{"$f":"$C$409","v":2.1144499295711947},{"$f":"$C$411","v":2.1144499295711947}]
["gLL ",{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2}]
["RFb",{"$f":"(B468-B471*B469)/(B472*B473)","v":28.709194339099295},{"$f":"(C468-C471*C469)/(C472*C473)","v":31.437934039584263},{"$f":"(D468-D471*D469)/(D472*D473)","v":31.437934039584263},{"$f":"(E468-E471*E469)/(E472*E473)","v":28.709194339099295},{"$f":"(F468-F471*F469)/(F472*F473)","v":28.709194339099295}]
[]
["II. Rating based on thrust"]
["      Load Rating Factor (RFt):"]
[]
[]
[]
["Load Rating Factors, RFO"]
[null,"NRL","SU4","SU5","SU6","SU7"]
["σcap",{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33},{"$f":"$D$51","v":33}," "]
["σS ",{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931},{"$f":"$D$79","v":0.19718309859154931}]
["σW",{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0},{"$f":"$D$86","v":0}]
["σD_bw",{"$f":"$D$99","v":6.3647697335448763},{"$f":"$D$99","v":6.3647697335448763},6.3647697335448763,6.3647697335448763,6.3647697335448763]
["gEV ",{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95},{"$f":"Input!$C$51","v":1.95}]
["σL",{"$f":"$D$418","v":9.5299151755321443E-2},{"$f":"$D$424","v":8.702740659261908E-2},{"$f":"$D$430","v":8.702740659261908E-2},{"$f":"$D$436","v":9.5299151755321443E-2},{"$f":"$D$442","v":9.5299151755321443E-2}]
["σL_bw",{"$f":"D446","v":3.0761112948184772},{"$f":"D449","v":2.8091119747387152},{"$f":"D452","v":2.8091119747387152},{"$f":"D455","v":3.0761112948184772},{"$f":"D458","v":3.0761112948184772}]
["gLL ",{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2},{"$f":"Input!$C$54","v":2}]
["RFf",{"$f":"(B483-B487*(B484+B485+B486))/(B490*(B488+B489))","v":3.1853637865072568},{"$f":"(C483-C487*(C484+C485+C486))/(C490*(C488+C489))","v":3.4881249341055969},3.4881249341055969,3.1853637865072568,3.1853637865072568]
[]
["G. Summary"]
["Load Rating Summary:"]
["Load","GVW","Rating Factor","Safe Load"]
[{"$f":"B482","v":"NRL"},20.5,{"$f":"MIN(B474,B491)","v":3.1853637865072568},{"$f":"B496*C496","v":65.299957623398768}]
[{"$f":"C482","v":"SU4"},36.5,{"$f":"MIN(C474,C491)","v":3.4881249341055969},{"$f":"B497*C497","v":127.31656009485428}]
[{"$f":"D482","v":"SU5"},40,{"$f":"MIN(D474,D491)","v":3.4881249341055969},{"$f":"B498*C498","v":139.52499736422388}]
[{"$f":"E482","v":"SU6"},40,{"$f":"MIN(E474,E491)","v":3.1853637865072568},{"$f":"B499*C499","v":127.41455146029027}]
[{"$f":"F482","v":"SU7"},44,{"$f":"MIN(F474,F491)","v":3.1853637865072568},{"$f":"B500*C500","v":140.15600660631929}]

{"sheet":"Summary","index":5,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[57,0,57,10],[58,0,58,10],[59,0,59,10],[60,0,60,10],[61,0,61,10],[54,1,54,3],[45,6,45,7],[45,12,45,13],[46,6,46,7],[46,12,46,13],[47,12,47,13],[51,1,51,3],[52,1,52,3],[52,4,52,5],[52,6,52,7],[53,1,53,3],[53,5,53,7],[40,0,40,1],[41,0,41,1],[43,6,43,8],[43,12,43,13],[20,0,22,0],[20,1,22,1],[20,2,20,5],[20,6,20,10],[21,2,22,2],[44,6,44,8],[44,12,44,13],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,10,22,10],[18,0,18,2],[18,4,18,5],[18,8,18,10],[19,0,19,2],[19,8,19,10],[16,0,16,2],[16,4,16,5],[16,8,16,10],[17,0,17,2],[17,4,17,5],[17,8,17,10],[13,8,13,10],[14,0,14,2],[14,4,14,6],[14,8,14,10],[15,4,15,5],[15,8,15,10],[12,8,12,10],[7,1,7,2],[7,4,7,6],[7,8,7,10],[8,1,8,2],[8,4,8,6],[8,8,8,10],[9,1,9,2],[9,4,9,6],[9,8,9,10],[10,1,10,10],[11,8,11,10],[5,1,5,2],[5,4,5,6],[5,8,5,10],[6,1,6,2],[6,4,6,6],[6,8,6,10],[0,8,0,10],[1,0,1,10],[2,8,2,10],[3,8,3,10],[4,1,4,2],[4,4,4,6],[4,8,4,10]]}
[]
["  Bridge Load Rating Summary Sheet"]
["Bridge Data"]
[]
["District    ",{"$f":"Input!B3","v":2},null,"Structure Number",{"$f":"Input!E3","v":2264300100701},null,null,"Bridge Name ",{"$f":"Input!K3","v":"Drain Canal"}]
["Parish   ",{"$f":"Input!B4","v":26},null,"Recall Number",{"$f":"Input!E4","v":20459},null,null,"Inspection Date",{"$f":"Input!K4","v":"02/12/2018"}]
["Route",{"$f":"Input!B5","v":"LA 3139"},null,"Year Built",{"$f":"Input!E5","v":1986},null,null,"Overall",{"$f":"Input!K5","v":"7"}]
["Bridge Posting",{"$f":"Input!B6","v":"-"},null,"Design Load",{"$f":"Input!E6","v":"-"},null,null,"Deck",{"$f":"Input!K6","v":"N"}]
["Bridge Type",{"$f":"Input!B7","v":"STLPIP"},null,"Roadway Width",{"$f":"Input!E7","v":38},null,null,"Super",{"$f":"Input!K7","v":"N"}]
["Bridge Length",{"$f":"Input!B8","v":25},null,"Plan Location"," ",null,null,"Sub",{"$f":"Input!K8","v":"N"}]
["Standard Plan",{"$f":"Input!B9","v":" "}]
[]
["Bridge/Culvert Load Rating Summary"]
[]
["Dead Load",null,null,null,"LRFR Evaluation Factors",null,null,"Traffic"]
["Wearing Surface Thickness (in)",null,null," ","Condition Factor, super (φc)",null,{"$f":"Input!F14","v":"-"},"ADTT (one way)",200]
["Wearing Surface Type",null,null," ","Condition Factor, sub (φc)"]
["Non-Structural Attachments",null,null,{"$f":"Input!D16","v":"-"},"System Factor, super (φs)",null,{"$f":"Input!F15","v":1}]
["Fill Thickness (in)",null,null,{"$f":"Input!D14","v":63},"System Factor, sub (φs)"]
[]
["Vehicle Type","GVW (kips)","Superstructure/Deck/Culvert",null,null,null,"Substructure"]
[null,null,"Rating Factor","Rating Weight (tons)","Controlling Member","Controlling Load Effect","Rating Factor","Posting Weight (tons)","Controlling Member",null,"Controlling Load Effect"]
[]
["HL-93 (INV)","N/A",{"$f":"MIN('Design Load Rating'!$D$317:$D$318)","v":2.6595211524683875}]
["HL-93 (OPR)","N/A",{"$f":"MIN('Design Load Rating'!$D$319:$D$320)","v":3.4475274198664283}]
["LADV-11(INV)","N/A"]
["LA Type 3",41,{"$f":"'State Legal Load Rating'!C487","v":4.0794750929488721},{"$f":"+Calcs!G20","v":83.629239405451884},null,null,null,{"$f":"IF(ISNUMBER(G27),Calcs!M20,\"\")","v":""}]
["LA Type 3S2",73,{"$f":"'State Legal Load Rating'!C488","v":4.0794750929488721},{"$f":"+Calcs!G26","v":148.90084089263382},null,null,null,{"$f":"IF(ISNUMBER(G28),Calcs!M21,\"\")","v":""}]
["Type 3-3",80,{"$f":"'State Legal Load Rating'!C489","v":4.6622572490844254},{"$f":"+Calcs!G27","v":186.49028996337702},null,null,null,{"$f":"IF(ISNUMBER(G29),Calcs!M22,\"\")","v":""}]
["LA Type 6",80,{"$f":"'State Legal Load Rating'!C490","v":3.5626045381602673},{"$f":"+Calcs!G28","v":142.50418152641069},null,null,null,{"$f":"IF(ISNUMBER(G30),Calcs!M23,\"\")","v":""}]
["LA Type 8",88,{"$f":"'State Legal Load Rating'!C491","v":3.5626045381602673},{"$f":"+Calcs!G29","v":156.75459967905175},null,null,null,{"$f":"IF(ISNUMBER(G31),Calcs!M24,\"\")","v":""}]
["NRL",80,{"$f":"'SHV Load Rating'!C496","v":3.1853637865072568},{"$f":"+Calcs!G19","v":83.629239405451884},null,null,null,{"$f":"IF(ISNUMBER(G32),Calcs!M25,\"\")","v":""}]
["SU4",54,{"$f":"'SHV Load Rating'!C497","v":3.4881249341055969},{"$f":"+Calcs!G21","v":94.179373220851119},null,null,null,{"$f":"IF(ISNUMBER(G33),Calcs!M26,\"\")","v":""}]
["SU5",62,{"$f":"'SHV Load Rating'!C498","v":3.4881249341055969},{"$f":"+Calcs!G22","v":108.1318729572735},null,null,null,{"$f":"IF(ISNUMBER(G34),Calcs!M27,\"\")","v":""}]
["SU6",69.5,{"$f":"'SHV Load Rating'!C499","v":3.1853637865072568},{"$f":"+Calcs!G23","v":110.69139158112718},null,null,null,{"$f":"IF(ISNUMBER(G35),Calcs!M28,\"\")","v":""}]
["SU7",77.5,{"$f":"'SHV Load Rating'!C500","v":3.1853637865072568},{"$f":"+Calcs!G24","v":123.4328467271562},null,null,null,{"$f":"IF(ISNUMBER(G36),Calcs!M29,\"\")","v":""}]
["Lane-Type I","N/A"]
["Lane Type II","N/A"]
[]
[]
[]
[]
["Posting Analysis Summary",null,null,null,null,"Please Check the following boxes that apply:"]
[null,null,null,null,null,null,"Plans do not exist"]
["Governing Rating Factor",null,null,{"$f":"Calcs!F31","v":3.5626045381602673},null,null,"Exterior girder controls the load rating"]
["Governing Load Model",null,null,{"$f":"+Calcs!B31","v":"LA Type 6"},null," ","As-designed rating"]
["Recommended Posting Load",null,null,{"$f":"+Calcs!H31","v":"No Limit"},null,null,"Striped lane rating"]
[]
[]
["QC/QA"]
[]
["Rated By:"]
["Checked By:",null,null,null,"Design Project Number:"]
["QA By:",null,null,null,"Rating Software:"]
["Date Rated:"]
[]
["NOTES"]

{"sheet":"Modulus of Soil Reaction","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calcs","index":7,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[[1,1,1,4],[18,0,24,0],[25,0,29,0]]}
[]
[null,"Posting Sign Table"]
[null,"Group A","Group B"," Sign #","Post Sign"]
[null,0,0,1,"Closed"]
[null,3,3,2,"3"]
[null,4,4,3,"4"]
[null,5,5,4,"5"]
[null,10,15,5,"10-15"]
[null,15,25,6,"15-25"]
[null,20,35,7,"20-35"]
[null,25,40,8,"25-40"]
[null,"<=25",">40",9,"25-NL"]
[null,"<=30",">40",10,"30-NL"]
[null,"<=35",">40",11,"35-NL"]
[null,">35",">40",12,"No Limit"]
[]
[]
[null,"Vehicle Type","GVW (kips)","Super RF","Sub RF","Min RF","Post Weight"," Post Sign ","Sign #",null,"WT IF RF<1",null,"Sub WT"]
["Group A","NRL",80,{"$f":"+Summary!C32","v":3.1853637865072568},{"$f":"+Summary!G32","v":0},{"$f":"IF(E19=0,D19,MIN(D19:E19))","v":3.1853637865072568},{"$f":"PostingWeight(F20,C20)","v":83.629239405451884},null,null,null,null,null,{"$f":"INT((IF(E19<0.3,0,IF(AND(E19>=0.3,E19<1),(C19/(2*0.7))*(E19-0.3),IF(E19>=1,(C19/2)*(E19),\"error\")))*100+0.5))/100","v":0}]
[null,"LA Type 3",41,{"$f":"Summary!C27","v":4.0794750929488721},{"$f":"Summary!G27","v":0},{"$f":"IF(E20=0,D20,MIN(D20:E20))","v":4.0794750929488721},{"$f":"PostingWeight(F20,C20)","v":83.629239405451884},{"$f":"postingsignA(G20,F20,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H20,$E$4:$E$15,0))","v":12},null,{"$f":"IF(F20<1,PostingWeight(F20,C20), 40)","v":40},null,{"$f":"INT((IF(E20<0.3,0,IF(AND(E20>=0.3,E20<1),(C20/(2*0.7))*(E20-0.3),IF(E20>=1,(C20/2)*(E20),\"error\")))*100+0.5))/100","v":0}]
[null,"SU4",54,{"$f":"Summary!C33","v":3.4881249341055969},{"$f":"Summary!G33","v":0},{"$f":"IF(E21=0,D21,MIN(D21:E21))","v":3.4881249341055969},{"$f":"PostingWeight(F21,C21)","v":94.179373220851119},{"$f":"postingsignA(G21,F21,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H21,$E$4:$E$15,))","v":12},null,{"$f":"IF(F21<1,PostingWeight(F21,C21), 40)","v":40},null,{"$f":"INT((IF(E21<0.3,0,IF(AND(E21>=0.3,E21<1),(C21/(2*0.7))*(E21-0.3),IF(E21>=1,(C21/2)*(E21),\"error\")))*100+0.5))/100","v":0}]
[null,"SU5",62,{"$f":"Summary!C34","v":3.4881249341055969},{"$f":"Summary!G34","v":0},3.4881249341055969,{"$f":"PostingWeight(F22,C22)","v":108.1318729572735},{"$f":"postingsignA(G22,F22,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H22,$E$4:$E$15,))","v":12},null,{"$f":"IF(F22<1,PostingWeight(F22,C22), 40)","v":40},null,0]
[null,"SU6",69.5,{"$f":"Summary!C35","v":3.1853637865072568},{"$f":"Summary!G35","v":0},3.1853637865072568,{"$f":"PostingWeight(F23,C23)","v":110.69139158112718},{"$f":"postingsignA(G23,F23,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H23,$E$4:$E$15,))","v":12},null,{"$f":"IF(F23<1,PostingWeight(F23,C23), 40)","v":40},null,0]
[null,"SU7",77.5,{"$f":"Summary!C36","v":3.1853637865072568},{"$f":"Summary!G36","v":0},3.1853637865072568,{"$f":"PostingWeight(F24,C24)","v":123.4328467271562},{"$f":"postingsignA(G24,F24,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H24,$E$4:$E$15,))","v":12},null,{"$f":"IF(F24<1,PostingWeight(F24,C24), 40)","v":40},null,0]
[null,{"$f":"IF(F25>=1,INDEX(B20:B24,MATCH(F25,F20:F24,0)),INDEX(B20:B24,MATCH($G$25,$G20:$G24,0)))","v":"SU6"},null,null,null,{"$f":"MIN(F20:F24)","v":3.1853637865072568},{"$f":"IF(I25=12,INDEX(G20:G24,MATCH(F25,F20:F24,0)),K25)","v":110.69139158112718},{"$f":"INDEX(H20:H24,MATCH($G$25,$G20:$G24,0))","v":"No Limit"},{"$f":"+MIN(I20:I24)","v":12},null,{"$f":"IF(I25=12,0,IF(MAX(K20:K24)=0,0,SMALL(K20:K24,COUNTIF(K20:K24,0)+1)))","v":0}]
["Group B","LA Type 3S2",73,{"$f":"Summary!C28","v":4.0794750929488721},{"$f":"Summary!G28","v":0},{"$f":"IF(E26=0,D26,MIN(D26:E26))","v":4.0794750929488721},{"$f":"PostingWeight(F26,C26)","v":148.90084089263382},{"$f":"postingsignB(G26, F26)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H26,$E$4:$E$15,))","v":12},null,{"$f":"IF(F26<1,PostingWeight(F26,C26), 40)","v":40},null,0]
[null,"Type 3-3",80,{"$f":"Summary!C29","v":4.6622572490844254},{"$f":"Summary!G29","v":0},4.6622572490844254,{"$f":"PostingWeight(F27,C27)","v":186.49028996337702},{"$f":"postingsignB(G27, F27)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H27,$E$4:$E$15,))","v":12},null,{"$f":"IF(F27<1,PostingWeight(F27,C27), 40)","v":40},null,0]
[null,"LA Type 6",80,{"$f":"Summary!C30","v":3.5626045381602673},{"$f":"Summary!G30","v":0},3.5626045381602673,{"$f":"PostingWeight(F28,C28)","v":142.50418152641069},{"$f":"postingsignB(G28, F28)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H28,$E$4:$E$15,))","v":12},null,{"$f":"IF(F28<1,PostingWeight(F28,C28), 40)","v":40},null,0]
[null,"LA Type 8",88,{"$f":"Summary!C31","v":3.5626045381602673},{"$f":"Summary!G31","v":0},3.5626045381602673,{"$f":"PostingWeight(F29,C29)","v":156.75459967905175},{"$f":"postingsignB(G29, F29)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H29,$E$4:$E$15,))","v":12},null,{"$f":"IF(F29<1,PostingWeight(F29,C29), 40)","v":40},null,0]
[null,{"$f":"IF(F30>=1,INDEX(B26:B29,MATCH(F30,F26:F30,0)),INDEX(B26:B29,MATCH($G$30,$G26:$G29,0)))","v":"LA Type 6"},null,null,null,{"$f":"MIN(F26:F29)","v":3.5626045381602673},{"$f":"IF(I30=12,INDEX(G26:G29,MATCH(F30,F26:F29,0)),K30)","v":142.50418152641069},{"$f":"INDEX(H26:H29,MATCH($G$30,$G26:$G29,0))","v":"No Limit"},{"$f":"MIN(I26:I29)","v":12},null,{"$f":"IF(I30=12,0,IF(MAX(K26:K29)=0,0,SMALL(K26:K29,COUNTIF(K26:K29,0)+1)))","v":0}]
["Critical",{"$f":"IF(F31>=1,INDEX(B20:B29,MATCH(F31,F20:F29,0)),INDEX(B20:B29,MATCH($G$31,$G20:$G29,0)))","v":"LA Type 6"},null,null,null,{"$f":"IF(I31=9,SMALL(F$20:F$29,COUNTIF($F$20:$F$29,0)+1),INDEX(F20:F29,MATCH($G$31,$G20:$G29,0)))","v":3.5626045381602673},{"$f":"IF(I25<I30,G25,G30)","v":142.50418152641069},{"$f":"INDEX(H20:H29,MATCH($I$31,$I20:$I29,0))","v":"No Limit"},{"$f":"MIN(I25,I30)","v":12}]

{"sheet":"Options","index":8,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Pipe Shape"]
["Circular"]
[]
[]
[]
["Coating and Lining Type"]
["Flexible Lining and Coating"]
[]
[]
[]
["Water Load Options"]
["Yes"]
["No"]